Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have attached test QVW, need help to get result in 2 pivot tables.
Below expression are not working:
1) Aggr(sum(Amt)*(Pdate-Ddate),DocumentType,[Doc Des],[Late - On Time],Year,month)
2) Aggr(sum(Amt)*(Pdate-Ddate),DocumentType,[Doc Des],[Late - On Time],Year,month)/sum(amt)
Thank you!
Hi
I tried to see what values has Pdate - Ddate, but almost always is null:
I think you have to fix this first.
Regards
Ahh, and you can't use Aggr function as "final aggregation", if you need the sum, with this sum(Amt)*(Pdate-Ddate) is enough.
You have multiple instances of your Dates for each dimension of your Pivot. So you need to consider either Min or Max date for all possible combination like below
sum(Amt)* (max(Pdate)-max(Ddate))