Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Once again I need the assistance from you all.
I am preparing the dashboard and need to have the similar dimension as the end.
For example in the below table I have mentioned the BU twice. Actually we have the lengthy report for several branches therefore it is difficult to look at the indiviudal values and that is why we want to have BU twice so that the viewer can have ease while looking at the figures.
Region | BU | Record 1 | Record 2 | Record 3 | Record 4 | BU |
Asia | India | 1 | 1 | 1 | 1 | India |
China | 2 | 2 | 2 | 2 | China | |
Japan | 3 | 3 | 3 | 3 | Japan | |
Autralia | 4 | 4 | 4 | 4 | Autralia | |
Thailand | 5 | 5 | 5 | 5 | Thailand |
Thank you in Advance !!
Hi
Add an expression
= Only(BU)
That should do the trick (Oh, and set 'No Total' to avoid the dash in the total line)
Hope that helps
Jonathan
You can use BU twice as dimension (need to input BU once as calculated dimension), or just use BU once as dimension and then as expression (I would prefer latter).
Thank You so much It would really help me
but can I also give the same format setting as dimension in the report ?
Hi
Add an expression
= Only(BU)
That should do the trick (Oh, and set 'No Total' to avoid the dash in the total line)
Hope that helps
Jonathan
Hi,
Sorry for my late reply,
Thank You so much Jonathan.
Regards
Nikhil
Hi Nikhil,
You can just use BU once as dimension and then as expression Only(BU).
Hope it will help you
Pradip
Dear Pradip,
Yes, That will help.
Thank You.
Regards
Nikhil