PIVOT TABLE PROLEMS

[Carlaf_93]

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?

[Rohan]

Hello,

Try creating that if condition field in the Load editor part & then use the new derived field in the Pivot Table.

Regards,

Rohan.

[Carlaf_93]

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...

[Carlaf_93]

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?