Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have one Table with : Product, Day , Quantity
The Pivot Table has as dimensions Product , Day with sum(Quantity) as Expression.
How could I calculate the difference of the sum per product between e.g. Day 1 - Day7 , Day 6 - Day 4
Product Day 1 2 .... 7
A 90 100 ---- 75 To calculate 90-75 = 15 (The difference of the sum of Day 7 and Day 1 per product)
B 92 ---- 82 92-82=10
C 95 ---- 46 95-46=49
Thanks a lot
Hi Kosmas,
I think this is not possible. One Dimension, one Total.
Regards,
Antonio