PIVOT TAB AGGR %

philgood34 — Sun, 08 Oct 2017 15:28:04 GMT

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

Re: PIVOT TAB AGGR %

philgood34 — Mon, 09 Oct 2017 07:33:24 GMT

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