BPC Report

[michele_medaglia5]

Dear BPC Friends

I need your help regarding the below report, where the third columns is Actual but it doesn't show it and the business would like to see it as you can see in the second screenshot.

If I select repeat ID in the columns I get the result as shown in the third screenshot but it is not acceptable

thanks

Michele

[former_member186338]

Sorry, but absolutely not clear what are you doing!

[ib_m]

Hey colleague!

It seems you have blank members throughout the report. You need to repeat columns as you did in the 3rd screenshot and then use your format sheet to hide the text (make the font color same as background) for the blank members, if that makes sense

[michele_medaglia5]

thanks Ibai

[michele_medaglia5]

thanks Vadim for getting back to my message-

In the columns I selected CATEGORY and Date

Because the 1st and the 3rd columns (the 2nd column is a local member) have the same CATEGORY ID= Actual, it is being shown only once but I would need it twice but not in the second column

[former_member186338]

Full screenshots of all settings! Including local member setup

[michele_medaglia5]

very very simple.

I would like to see the category Actual repeated for the third column, the second column is a local member so I don't need it

[former_member186338]

Sorry again! But still everything is not clear!

What is selected in column axis?

Full description of local members used...

etc