Need Help..

[Nagaraju_KCS]

Hi Community,

PFA,

I have 2 dimensions and 2 expression.

first expression coming based on 2 dimensions.

but my second expression i want show based on only one dimension.(Month based)

Thanks in advance..

[maxgro]

sum({<Type={SALES,GRC}>}total <MonthYear> Quantity)

or

sum(total <MonthYear> Quantity)

[Gysbert_Wassenaar]

See attached qvw

[Nagaraju_KCS]

Hi Gysbert,

PFA,

Data is correct, but i need in expression only,..

i want to show same data  in all Sales columns.

Hope you understand...

[jagan]

Hi,

Try this expression

=Sum(TOTAL  <MonthYear> Quantity)

Regards,

Jagan.

[Nagaraju_KCS]

Hi Jagan,

This data correct... if  i am using this =Sum(TOTAL  <MonthYear> Quantity) it showing wrong data...

See here, sales column data i want to show all  sales column. 

[Gysbert_Wassenaar · Accepted solution]

Try this expression: sum(total <MonthYear> aggr(sum({<Type={'SALES'}>} Quantity),[MonthYear]))

[Nagaraju_KCS]

Thanks Gysbert..