-
Re: Strange pivot table behavior
Sunny Talwar Apr 7, 2017 11:56 AM (in response to Aleksandrs Jemeljanovs)What is the total you are expecting to see? I am trying to understand that bit
-
Re: Strange pivot table behavior
Aleksandrs Jemeljanovs Apr 10, 2017 4:29 AM (in response to Sunny Talwar )I want to get the 101 and 102 slide TOTAL <Month> disregarding the selections and drill-down states, like the ones I get in Screenshot 101 and 102, so basically it should show me the total costs per month in any of view combinations.
It would be the total cost of specific product per month.
-
Re: Strange pivot table behavior
Sunny Talwar Apr 10, 2017 6:08 AM (in response to Aleksandrs Jemeljanovs)May be this
If(Dimensionality() = 3, Aggr(nodistinct Sum(Cost), Month), Sum(TOTAL <Month> Cost))
-
PivotBehavior.qvf 176.0 K
-
Re: Strange pivot table behavior
Aleksandrs Jemeljanovs Apr 10, 2017 10:21 AM (in response to Sunny Talwar )Nice! It works when the Month is at the level 3, however, when I move the month to the second level, it breaks. Maybe You know the trick?
-
Re: Strange pivot table behavior
Sunny Talwar Apr 10, 2017 11:22 AM (in response to Aleksandrs Jemeljanovs)-
Re: Strange pivot table behavior
Alex Timofeyev Apr 10, 2017 5:37 PM (in response to Sunny Talwar )Sunny,
Look at the value for "January" on the second level under "Door". It's 305, but it's supposed to be 420, just like the levels below.
-
Re: Strange pivot table behavior
Sunny Talwar Apr 10, 2017 9:26 PM (in response to Alex Timofeyev )I see what you mean..... now.... I will take a look at this and
-
-
-
-
-
-