
Re: How to calculate the difference of sum in a PivotTable for specific values of one dimension
Antonio Mancini May 28, 2015 3:48 PM (in response to KOSMAS PAPAKOSMAS)Hi Kosmas,
see attachment.
Regards,
Antonio

Test.qvw 152.2 K

Re: How to calculate the difference of sum in a PivotTable for specific values of one dimension
KOSMAS PAPAKOSMAS May 28, 2015 4:16 PM (in response to Antonio Mancini)Hi Antonio,
Thank you for the answer.
If I go one step more and add also the difference between Day 2  Day4.
Could you please specify how would calculate both ?
Grazie
Kosmas

Re: How to calculate the difference of sum in a PivotTable for specific values of one dimension
Antonio Mancini May 28, 2015 4:20 PM (in response to KOSMAS PAPAKOSMAS)You select Day from 2 to 4.

Re: How to calculate the difference of sum in a PivotTable for specific values of one dimension
Antonio Mancini May 28, 2015 4:32 PM (in response to KOSMAS PAPAKOSMAS)In the same Column,
see attachment

Test.qvw 152.0 K

Re: How to calculate the difference of sum in a PivotTable for specific values of one dimension
KOSMAS PAPAKOSMAS May 28, 2015 4:47 PM (in response to Antonio Mancini)Hi Antonio,
The way you used min and max makes dynamic the case. This is very good.
Sum({<Day={"$(=Min(Day))"}>} Qty) Sum({<Day={"$(=Max(Day))"}>} Qty)
In the second file you include the Day 2  Day4 as a concatenation in Expression 1.
If you separate this concatenation in an another new expression, what should I take care of to be correct ?
Grazie mille
Kosmas

Re: How to calculate the difference of sum in a PivotTable for specific values of one dimension
Antonio Mancini May 28, 2015 4:54 PM (in response to KOSMAS PAPAKOSMAS)The column of concatenation is a TOTAL column.
You don't have two TOTAL.
However You can split Concatenation in 2 rows changing &' '& to &Chr(10)&.
If You want dynamic Days (4), You change Min(Day) and Max(Day) > Min(Day,1) Min(Day,2) Min(Day,3) Min(Day,4)
Regards,
Antonio

Re: How to calculate the difference of sum in a PivotTable for specific values of one dimension
KOSMAS PAPAKOSMAS Jun 3, 2015 10:06 AM (in response to Antonio Mancini)Hello Antonio,
Could you please explain the philosophy of the solution ?
Thanks
Kosmas

Re: How to calculate the difference of sum in a PivotTable for specific values of one dimension
Antonio Mancini Jun 3, 2015 10:43 AM (in response to KOSMAS PAPAKOSMAS)Hi Kosmas,
If You have 2 Interval (4 days) e.g 23 and 46
You can select in (Ctrl + Click).
In Expression Min(Days,1) is the First, Min(Days,2) the 2nd and so on.
You Replace Min(..) in TOTAL Expression.
If You want to split TOTAL in 2 rows, You replace &' '& with &Chr(10)&.
(In Grafic panel Text Cells = 2 rows).
Regards,
Antonio

Re: How to calculate the difference of sum in a PivotTable for specific values of one dimension
KOSMAS PAPAKOSMAS Jun 5, 2015 6:14 PM (in response to Antonio Mancini)Can I have more than one column for the Total ?
One having the 23 and the next column having 46, instead of having them concatenated.
Grazie
Kosmas

Re: How to calculate the difference of sum in a PivotTable for specific values of one dimension
Antonio Mancini Jun 6, 2015 4:14 AM (in response to KOSMAS PAPAKOSMAS)Hi Kosmas,
I think this is not possible. One Dimension, one Total.
Regards,
Antonio







