Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am facing a problem to write a expression.
I am attaching the demo qv app , excel data , and requirement in excel.
Please find the attachment herewith.
Please give me a needful solution to write the expression.
Thanx in advance
Regards,
Sukamal
Try This...
Give
Dimension as Division_Grp, Division, MTD
Expression : =MTD / AGGR(nodistinct MAX(MTD),Division_Grp)
Hi Sukamal, If you want the value representes a division over their Division_grp expression can be:
Sum(MTD)/Sum(TOTAL <Division_Grp> MTD)
But it only works if you avoid to load the totals from excel and let QV to calculate. If you have Excel without the totals this can work.
Or else you can add a where clause to avoid loading totals:
Where not(Division='Men' and Division_Grp='Men') and not(Division='Ladies' and Division_Grp='Ladies');