Measure multiplied by dimension does not show total value

[Ernests]

Hi Experts,

I believe there is a simple solution for this problem but can't solve it now.

I have a pivot table with multiple dimensions and measures. One of the columns (values part in pivot table) is made price (which is dimension) multiplied by sum of visits (which is measure). Results are correct but if I try to get totals row, it does not have a value. I tried to use sum(aggr... but did not get correct results.

Measure now look like this: [dimension1] * sum({< type = {1} >} [visit.count])

Any ideas?

[Muthukumar_77]

Hi,

Any sample data?

[Ernests]

Thanks for your reply!

Hope this helps:

sum(skaits) multiplied by dimension column. For example 36 x 84 = 3024. But totals row is not calculated.

[Muthukumar_77 · Accepted solution]

Try Below expression,

 sum({< type = {1} >} [dimension1] * [visit.count])

[Ernests]

Yes, simple as that worked. I thought I already tried this. Thanks!