$ % of Each Category per Quarter

[Anonymous]

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

[Anonymous · Accepted solution]

Doesnt seem like you can do it with the "relative" button so i settle on

= sum({< Category {'category_1'}>} Amount)/ sum(Amount)