Spread totals over dimension values

[StefanE]

Good Day Everyone,

This is probably a pretty basic question: 

As shown in the example below, I want to spread out the Total of my "Products" Dimension, in this case, per month: 

So what I would want to display is the Product A, Product B and the Total per month.

Is this possible in QS pivot table or do I need to use a different approach?

Apologies if there's an existing thread on this topic.

Kind regards

Stefan 

[MayilVahanan]

HI Stefan,

Try like below

In script , bring one dummy field 

Load * inline

[

Dim

1

2

];

In front end, try like below

Dim1: Year

Dim2: If(Dim=1, 'Product Total', Products) 

Label as Products

Dim3: Month

Exp: Urexpression

Now, if you expand the Year, You can see additional value "Product Total" and if you expand it, you can see all the months & its total values.

Something like below

[stevejoyce]

In a pivot table properties, for each Dimension, you can "Show totals".  Is that what you are trying to enable?

[StefanE]

Hi Mayil,

Thanks so much for your reply! Since it's not my application I rather don't mess with the script. Is there a way to do it on the front end?

[StefanE]

Hi Steve, I've got the totals for products in pivot table. What I know want is the products total for each month. The thing I get is the products total for all months. 

[stevejoyce]

Maybe i'm misunderstanding, but if you enable Show totals on your Product dimension also, that sounds like what you want?...

Currently you have Show totals on your Month dimension only.

[StefanE]

I highlighted both totals for you:

No Product Total per month, unfortunately