Skip to main content
Announcements
Do More with Qlik - Qlik Cloud Analytics Recap and Getting Started, June 19: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
tmumaw
Specialist II
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
tmumaw
Specialist II
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)

View solution in original post

8 Replies
vishsaggi
Champion III
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))

tmumaw
Specialist II
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.

ahaahaaha
Partner - Master
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.

tmumaw
Specialist II
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

tmumaw
Specialist II
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)

ahaahaaha
Partner - Master
Partner - Master

May be approach to the solution as in attached file.

tmumaw
Specialist II
Specialist II
Author

Thanks for your help Andrey.  Have a great day.

chaper
Creator III
Creator III

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