Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi need the percentage of my Column; the dimensions are Prod, Esp, but the dimension Tot is created; the total for Esp1 is 91, the percentaje is 11/91
What is the expression for Mat0? Assuming it is Sum(Measure), you can try this
Sum(Measure)/Sum(TOTAL <Esp> Measure)
Try this
Sum({<Mes={'M24','M23','M22','M21','M20','M19','M18','M17','M16','M15','M14','M13'}>} Px)/
Sum(TOTAL <Esp> {<Mes={'M24','M23','M22','M21','M20','M19','M18','M17','M16','M15','M14','M13'}>} Px)
Hi, good mornig.
I need %P1 = 11/91
91 is total horizontal for Esp1
11 is Mat0 value