Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot table questions

1) I have a total in my pivot table. But it goes to the top. How do it make it come to the bottom?

2) I have created two pivot tables but when I change the parameter in one pivot table, it changes it on the other. How do i decouple them?

7 Replies
sunny_talwar

1)  On the presentation tab, you can select Subtotals at the Bottom

Capture.PNG

2) Change the Object ID on one of them to un-link them

Capture.PNG

Not applicable
Author

How do you get to that screen? All I see is this in my Pivot design

Capture.PNG

swuehl
MVP
MVP

With regard to 2), which parameter are you changing?

If you are using e.g. a dimension group and change the dimension field in one chart, this will also affect all other charts that use the same dimension group (in other words, the current field is a property of the group, not the chart).

Not applicable
Author

I am changing a dimension

sunny_talwar

Sorry I thought this was QlikView. Not really know how Qlik Sense work

Not applicable
Author

Thanks

Not applicable
Author

How do I get to the presentation tab?