Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a dimension and a few expressions. I want the second expression to be independant of the dimension.
I tried.
Sum({<Dimesnion1=>} measure), but doesn't seem to work at all. My intention is even if the dimension evaluates to NULL, the expression should still yield results.
Thanks,
Ram
Hi Ram,
Can you tell me how many dimension and expression in your chart? and what is your expression definition?
Regards,
Sokkorn
Hi Sokkorn, I have got 2 dimensions and a number of expressions. This particular expression which I want to exclude dimension1 is as follows.
=Sum({<WEEK_445_TXT=>}total<[Product Attributes]>[Stock Book Qty])
Hi Ram,
Your expression look like ok. Can you share your app? You can scrambling your data via this doc
Regards,
Sokkorn
Hi,
Can you attach some sample data and come up with an example, it would be easier to understand and give the solution.
Regards,
Jagan.
Hi, Attaching the document. I want the pivot table to display units as 11 and not -45. (Similar to the chart on the right).
Try this
sum(Aggr(NODISTINCT sum(TOTAL [Stock Book Qty]),WEEK_445_TXT))
Hi Mohit, Thanks for that. It seemed to work at the first sight, but once I clear the selection it gave undesirable results.
I tried this expression.
sum({<AsOf445Year=,YEAR_445=,MONTH_445_TXT=,WEEK_445_TXT=,DAY_445=>}Aggr(sum({<AsOf445Year=,YEAR_445=,MONTH_445_TXT=,WEEK_445_TXT=,DAY_445=>} [Stock Book Qty]),WEEK_445_TXT,[Product Attributes]))
But of no use.
You can see once I clear the store selection it gives an extraordinary number for Owen. I have attached the qvw again with your expression and the store selection cleared.