Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have my pivot(dim1 Prod, dim2 Esp), but want repeat sum Mat0 value in col Tot; % =Mat0/Tot
Mat0=Sum({<Mes={'M24','M23','M22','M21','M20','M19','M18','M17','M16','M15','M14','M13'}>} Px)
Hi Ronald,
Can you please explain your requirement a bit more ? A sample data and expected output sample will be helpful to understand.
Hi, good mornig.
I need %P1 = 11/91
91 is sum horizontal for Esp1
11 is Mat0 value
Mat0=Sum({<Mes={'M24','M23','M22','M21','M20','M19','M18','M17','M16','M15','M14','M13'}>} Px)