Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have several categories of spend - lets just say A,B and C
I want to visualize the spend PERCENTAGE of each category per QUARTER
I thought this would be easy, but every time I try to choose relative in a bar chart or straight table it gives me the percentage of that category/quarter pair VS ALL quarters.
Again, I just want to see the spend percentage of each category per each seperate quarter.
any help is appreciated.
- dave
Doesnt seem like you can do it with the "relative" button so i settle on
= sum({< Category {'category_1'}>} Amount)/ sum(Amount)
Doesnt seem like you can do it with the "relative" button so i settle on
= sum({< Category {'category_1'}>} Amount)/ sum(Amount)