topic Re: Create pivot table measure not aggregated across columns in App Development

Create pivot table measure not aggregated across columns

Thu, 12 Jan 2017 11:51:59 GMT

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 — Thu, 12 Jan 2017 12:05:48 GMT

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

Thu, 12 Jan 2017 13:07:22 GMT

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 — Thu, 12 Jan 2017 13:08:33 GMT

calculated dimensions does allow you to use aggregations

Thu, 12 Jan 2017 13:18:32 GMT

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

Thank you for your time

sunny_talwar — Thu, 12 Jan 2017 13:22:22 GMT

Hahaha yes!!

jyoti_accenture — Fri, 29 May 2020 11:59:44 GMT

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