Regarding Calculation

[pjpkumar26]

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

[marcus_sommer]

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

[pjpkumar26]

Hi Marcus,

Thanks for your quick reply I used total within the outer aggregation and it worked

Thanks,

Sudheer