Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I have a Pivot table with 2 Measures that behave in different way when grouped (I mean the line with the number 3818).
As you can see, the left measure (Resa Fonderia) is an Average calculation, while the other one (% Scarto Totale) is a Sum.
I need to have the Sum on both measures.
Below the measure called % Scarto Totale.
And here the one called Resa Fonderia.
Thanks a lot.
What exactly do you mean when you say you want sum in both measure? Can you provide the numbers you expect to see? Are we only talking about the totals or the individual rows are incorrect as well?
Try this
Sum(Aggr(YourExpression, Stampo, CDL, Data))
I tried but I get 0 in each field.
The formula now is:
Sum(Aggr(Sum([S_ODL.LORDO_FONDERIA])/Sum({<[C_FASI.PRAV]-= {3}, [DT_ARTICOLI.TCICMEDSTD]={">0"}>} [S_ODL.DURATA]/[DT_ARTICOLI.TCICMEDSTD]), Mid([L_ODL.CODPARTE],4,4), [S_ODL.CODCDL], KEY_DATA))
You will need to create a new field for this in the script
Mid([L_ODL.CODPARTE],4,4) as ...
Aggr function's dimension cannot be used with calculated dimensions
It works great!
Thank you very much!
(Have you seen the other post I made? Maybe you can help me also there...)