Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good mornig,
when i have a pivot tableand i use an if conditions it works on a specific level..
But when i close all the elements the total sum isn't right.
The if statements give me problem. How can i do?
Hello,
Try creating that if condition field in the Load editor part & then use the new derived field in the Pivot Table.
Regards,
Rohan.
I thought about it but it's a little complicated... I use a variable to calculate the specific sum because it's a little complex.
In a nuthsell, if the filed month is selected for a specific code i need some calculations on specific element's in another table.... An d there are variables in the middle...
The other solutions is to use a normal table but i would like to have sums in there...
For example having a total for every different type of BIG-CODE:
Do you know how to do it instead?