Announcements
Do More with Qlik - Qlik Cloud Analytics Recap and Getting Started, June 19: REGISTER
cancel
Showing results for
Did you mean:
Specialist II

## Pivot Table

Okay group here is an easy one for you all.  I have pivot table that is broken down by GL Hier 3 I want to compare it to gross sales.  How do I get the pivot table to ignore the dimension and just put in total gross sales.  I have created a summary table with just gross sales by profit center and year.

1 Solution

Accepted Solutions
Specialist II
Author

Andrey I need to get Gross Sales on every line to do the % to gross calculation.  Any ideas?  Fixed had to use the following:

sum(TOTAL <FISYR> {<[GL Hier 3] = {'Gross Sales'}>}[In company code currency_HSL]  * -1)

8 Replies
Champion III

What is the expression you used and what is your expected output in Gross Sales column. ?

May be like:

= Sum({<GLHeir3=>} Aggr(Sum({<GLHeir3=>}Sales), ProfitCenter, Year))

Specialist II
Author

I created a link key made up of Profit Center and Date and then I summed the total gross sales amount.  For some reason the Gross Sales amount is still blank. GLPCA is the detail table.

Partner - Master

You need to analyze the load script. Something is wrong with joining the SalesVIP table. I think, to help you, need the fragment of your source data and script code.

Specialist II
Author

This calculation did not work.  I am trying to find out what expenses are to gross sales.  The column labeled Gross sales should be the same on every line and ignore the dimension GL Hier 3.  The second image shows gross sales only showing up in one GL Hier 3 row.  However I need it to show up in all rows to do the calculation % to Gross

Specialist II
Author

Andrey I need to get Gross Sales on every line to do the % to gross calculation.  Any ideas?  Fixed had to use the following:

sum(TOTAL <FISYR> {<[GL Hier 3] = {'Gross Sales'}>}[In company code currency_HSL]  * -1)

Partner - Master

May be approach to the solution as in attached file.

Specialist II
Author

Thanks for your help Andrey.  Have a great day.

Creator III

Did you tried with something  like this Sum({<GLHeir3=>}Total Sales)

Community Browser