Create pivot table measure not aggregated across columns

[#1]

Dear Community,

I have a major case that involves creating a measure in a pivot table that is not aggregated across columns.

For example, in the below table I want to add a standalone measure, have it aggregated across category and product but not the Month column.

In other words, just a standalone measure at the start of the table.

I tried searching for an extension that might help, but couldn't find any.

Any suggestion would be much appreciated,

Regards,

Rawad

[sunny_talwar]

May be use it as a calculated dimension? Would you be able to share your expression?

[#3]

Any kind of aggregation expression, i.e sum(Sales).

A calculated dimension would not help because it doesn't allow aggregation functions, i.e Sum, Avg, etc..

Any thoughts ?

[sunny_talwar · Accepted solution]

calculated dimensions does allow you to use aggregations

Calculated Dimensions

[#5]

It doesn't work unless AGGR function is used, but what's important is that it works.

Thank you for your time

[sunny_talwar]

Hahaha yes!!

[jyoti_accenture]

Hey, what was the solution for this issue. I am trying to achieve this in qlik sense.