Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
Try this expression: sum(total <MonthYear> aggr(sum({<Type={'SALES'}>} Quantity),[MonthYear]))
sum({<Type={SALES,GRC}>}total <MonthYear> Quantity)
or
sum(total <MonthYear> Quantity)
See attached qvw
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...
Hi,
Try this expression
=Sum(TOTAL <MonthYear> Quantity)
Regards,
Jagan.
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.
Try this expression: sum(total <MonthYear> aggr(sum({<Type={'SALES'}>} Quantity),[MonthYear]))
Thanks Gysbert..