Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

bibopipo
Contributor II

Dimension in pivot table

Dear all,

I'm wondering if it is possible to use a calculated dimension into pivot table in the following way

Pivot tabel

Customer     TOTAL SALES          % of TOTALSALES

A                    1000                                   10%

B                    2000                                   20%

C                    5000                                   50%

...

The table above has two dimensions: Customer and TOTAL SALES  (aggr (sum(Sales), Customer)

How can I calculate the espressione % of TOTALE SALES ? Is it possible to use the dimension TOTAL SALES ?

I'm a bit confused.

Thanks in advance

2 Replies
MVP
MVP

Re: Dimension in pivot table

Not sure why you want or need a calculated dimension for this ( I would use just an expression for TOTAL SALES, sum(Sales) ), but the % should look like this in both cases:

=sum(Sales) / sum(total Sales)

This gives different values than in your sample:

A        12.5 %

B        25 %

C        62.5 %

but this looks correct for me (assuming a total Sales of 8000).

Stefan

whiteline
Honored Contributor II

Re: Dimension in pivot table

Hi, Stefan.

It's look like he've  skipped "D - 2000 - 20%"

Community Browser