Dverdon Member

Hi Juliene, i agree this does cause a headache when trying to finalise the layout, size of cards and font sizes on a dashboard, especially now peoples set ups vary so much with hybrid working, i can have a report which opens up fine for one user but a bit of a mess for another. if the above isn't possible could there be a…

@MichelleH Thank you, so something along the lines of the below - Figures at each level of the Hierarchy (company) showing values and monthly movements, ideally then drilling down the Hierarchy showing the breakdown by next layer (division)

Thanks - i have done the above steps but still get the value at the last level - the issue being the only option is to aggregate by count another workaround i was thinking is to change the font colour on that particular field as white so wouldnt show - however i dont think thats dobale? i think the font colour can only be…

here you go - Week commencing is the last level in the pivot rows

Thank you just tested and worked as expected - the only issue is still shows at the lowest level of the pivot row hierarchy (as isn't a total or subtotal)