Pivot Table Dimension (Sum)

[riceball]

Hi,

I'm trying to build a pivot table with a single dimension (Product) on the left side and two dimensions (Type and Category) along the top.

However, the result of totalling up the sales through "partial sum" features was like this:

I would like my output to look like this instead:

Currently, I'm maintaining 2 different tables which is quite troublesome. I would like to consolidate my results into a single table like the one above.

Please help. Thanks!!

[rohit214]

Hi ,

I think insted of selecting show partial sum option you should use an expression for total

Aggr(Sum(sales),Product,Category)

Thanks

Rohit

[riceball]

Hi,

I've tried the advance aggr method - Aggr(Sum(Sales),Product,Category) , but it still yield the same result

Thanks.

[rohit214]

then use

Sum(total<Product>Category) in total expression

[riceball]

Hi,

It's not working too. I think changing the expression script doesn't help unless I assigned one expression for each category/type. But that is way to much work as I have over 30 types at my end.

[sunilkumarqv]

check Category dimension partial sum in presentation

[riceball]

Partial sum works, but the output is not what I wanted. It does not sum up each category respectively

[sunilkumarqv]

[riceball]

Hi,

Thanks for your help! But is it possible to aggr the type for the 2nd expression. Instead of listing "large","medium","small", I would like to have just the "Total" and then breakdown by Type. This enables me to see the total sales for each color

[mohammadkhatimi]

Hie...

Check this ...