topic Re: Adding a Measure as a Dimension in Pivot Table in App Development

Adding a Measure as a Dimension in Pivot Table

datagrrl — Fri, 12 Apr 2024 12:45:45 GMT

I have a situation where I want a measure, like a weekly average for the dimension value to the dimension values in a pivot table. For example in the below I would like the overall average next to the state before the measure values by month.

Something more like this

Thanks in advance.

Re: Adding a Measure as a Dimension in Pivot Table

Anil_Babu_Samineni — Mon, 15 Apr 2024 10:05:26 GMT

Please share us the sample file or data in excel. So that, we can work for you and help.

Re: Adding a Measure as a Dimension in Pivot Table

marcus_sommer — Mon, 15 Apr 2024 11:00:16 GMT

You may try something like this as calculated dimension:

aggr(sum(Sales) / count(distinct Month), State)

Re: Adding a Measure as a Dimension in Pivot Table

stefanmereuta — Mon, 15 Apr 2024 12:56:10 GMT

You can show the average column next to the states using totals, without a new dimension. Change your measure to something like this:

Avg(Aggr(Sum(Sales), Month, State))

Then click your month dimension and turn on "Show totals". It should show the sum for each month and the average for all months in the first column.

Re: Adding a Measure as a Dimension in Pivot Table

datagrrl — Thu, 18 Apr 2024 13:26:15 GMT

Thanks, this helped them and we figured out a solution.