Calculated Dimension for Pivot Table

[cristian_av]

Hi

I want to to create a table like the one shown in the image below.

I have the following dimensions:

Day

Week

BultoStock

KiloStock

Any idea how to do this?

I think this can be done with calculated dimension, but cannot make it work!

[sunny_talwar]

Would you be able to share some sample raw data and explain the expected output?

[rupamjyotidas · Accepted solution]

In Dimension for sum()

=aggr(sum(BultoStock),Especie)

=aggr(sum(KiloStock),Especie)

Also you need the following dimension

Especie

day/week

Expression :

Sum(BultoStock)

Thanks

[cristian_av]

Thanks!

It works, but I can't show the Totals for the grouped dimensions. Any idea about how to do it?

If I use the "Show partial Sums", I get the following:

I've tried drag&drop but cannot make it work!

[rupamjyotidas]

Totals for the group dimension won't be possible, as Totals works only for Expressions.

[cristian_av]

I Solved it by putting another pivot table over the principal one.

Then I've hide the borders, change the background color.. and nobody will notice it hehe

[rupamjyotidas]

. Problem might come when users does selections. So test and Test:)