Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I created a pivot chart using avg sales per product.
Our products are summarized in categories.
Now I need to have a sum of the total avg per category instead of the avg per category.
is this posible?
Thanks in advance
Try this:
Sum(Aggr(YourExpression, YourDimensionsFromThePivotTable))
can you post sample app?
Not sure if I fully understand.
It would be helpful if you could explain your setting with some sample lines of data and expected result.
You may also need to check for expression evaluation per Dimensionality() or SecondaryDimensionality() (for horizontal dimensions) depending on your need to use different aggregations on different aggregation levels, like
=If(Dimensionality() = 0,
Sum( Aggr( Avg(Sales), Category, Product)), // or maybe Sum( Aggr( Avg(Sales), Category)) ?
Avg(Sales)
)
Hi Sunny,
The formula worked for the totals
But now the data of my columns doesn’t are changed.
Can you help me with that?
Before
After
What all dimensions do you have? and what expression did you use?
Maybe you forgot to add the Weekday dimension (omschriving?) to the aggr() dimension list?
Sum(Aggr(Avg(Aantal),Omschrijving))
Expression:
- Avg(aantal)
Dimensions:
- Artikel groep
- Omschrijving
Collumns
- Dag
Try this:
Sum(Aggr(Avg(Aantal),Omschrijving, [Artikel groep]))