I have data that is provided to me on a daily basis. This data that is provided is only provided in a cumulative fashion.
Example
Total Figures
6/24 - 25
6/23 - 20
6/22 - 15
I have an expression that gives me the added figures from below (works perfectly): sum(Figures)-below(sum(Figures)
6/24 - 5
6/23 - 5
6/22 - 5
However, when I try to add a dimension, my formula breaks.
The Figures are divided into categories. I would like to see, which categories are my daily figures coming from.
Example
6/24 - 25
Item A - 15
Item B - 10
6/24 - 20
Item A - 15
Item B - 5
My expression should be able to show that Item B was the only category to add values while item A stayed consistent.
In my Dimensions tab, I only have Date. I would like to include product in here and a formula that will provide me with the correct information I would like to see.
