Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am using the below code and I am getting the output perfect:
Count({<"Flag"={'Y'},"Type"={"Office"}>}total<[Week],[Dept]> [ID])
/
count(total distinct [Date])
output :
45.4
25.3
55.3
66.8
now I want to get the sum of all the above output in a different measure
like:
192.8
192.8
192.8
192.8
can you please suggest how can I total this value amending the above formula
Advance Thanks,
Sudheer
Depending on your data-model and the object-structure you could try to calculate your expression with a changed total statement - reflecting not to this granularity else to a higher ones.
Another approach would be to wrap your expression within an aggr, like:
sum(aggr(YourExpression, YourDim))
whereby I assume that you need an total within the outer aggregation, too to plot the results on each row, maybe like:
sum(total <YourDim> aggr(YourExpression, YourDim))
Hi Marcus,
Thanks for your quick reply I used total within the outer aggregation and it worked
Thanks,
Sudheer