Facing problem in writing a expression.

[#1]

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

[Anonymous]

Try This...

Give

Dimension as Division_Grp, Division, MTD

Expression : =MTD / AGGR(nodistinct MAX(MTD),Division_Grp)

[rubenmarin]

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');