PIVOT TAB AGGR %

[philgood34]

Hi,

I think i have a very classic issue with PIVOT TABLE, but i did'nt found solution for the time being ...

I demonstrate with a sample :

i have this PIVOT TABLE calculating cumulative  % MARGIN

first i calculate from absolute value  : it's working

Now i want to calculate from relative values.

So i have to use Aggr ()/total ...

Here my issue : my expression accumulate the values over the periods (Year & Month)

i tried also without Dimensionality ()=0

or with SecondaryDimensionality ()=0

No way :-((

An idea ?

Regards

Philippe

[philgood34]

Hi

I found the solution

It was not a issue concerning PIVOT TAB

My expression did’nt need AGGR !

Here is the good expression for my issue :

Sorry for that

on the other hand do you know how to decrease the width of the columns in a pivot table? is it possible ?

Regards

Philippe