Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
Would you be able to share some sample raw data and explain the expected output?
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
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!
Totals for the group dimension won't be possible, as Totals works only for Expressions.
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
. Problem might come when users does selections. So test and Test:)