I have following problem. I created a pivo table with a sum formula and an additional formual sum before for making a comparison. But the formula at the moment will be executed for every column. But I want that this sum before forumal should only executed for the dimension run.
Okay, I think this is the real example which shows my problem. In the example there are 2 tables. The table above is correct with the sum(Amount) and Sumbefore... for every run. But in the belowtable there is an additional dimension and after I take this dimension to the table there is no chance for me to become the logic of the table above.
What I want is that in the below table there should be the complete sum for every run. Is that possible?