- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Subtotals in straight table
Hi,
I know the option to get sub totals in a straight table by using show totals in the Dimension Limit Tab.
But i have a problem to get a subtotal by city in my example
What i want
Country | Region | City | item | quantity |
USA | Florida | Miami | A | 5 |
USA | Florida | Miami | B | 10 |
Total | 15 | |||
USA | Florida | St Pete | A | 10 |
Total | 10 | |||
Total | 25 | |||
USA | California | Los angeles | 30 | |
Total | 30 | |||
total | 30 | |||
Total | 55 |
What i get
Country | Region | City | item | quantity |
USA | Florida | Miami | A | 5 |
Total | 5 | |||
USA | Florida | Miami | B | 10 |
Total | 10 | |||
USA | Florida | St Pete | A | 10 |
Total | 10 | |||
Total | 25 | |||
USA | California | Los angeles | 30 | |
Total | 30 | |||
total | 30 | |||
Total | 55 |
If i want the country subtotal, i have to select show total in region dimension
If i want the region subtotal, i have to select show total in city dimension
logically, if I want the subtotal of the city, I select the item subtotal, but instead of making me a subtotal per city , it adds a subtotal for each items
The Quantity expression, is a simple sum.
I try to use a hiding dimension with no succes.
I hope to have been clear with this simple example, my app is a little more complex
Can someone help me ?
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
There you go.
You missed out a step to sort dimensions based on priority.
I did it both on straight table and pivot table and it works well.
Refer qvw attached to check on the configurations I did.
Thanks and regards,
Arthur Fong
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
There you go.
You missed out a step to sort dimensions based on priority.
I did it both on straight table and pivot table and it works well.
Refer qvw attached to check on the configurations I did.
Thanks and regards,
Arthur Fong
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks Arthur, your simple example help me to understand where i was wrong
A simple column sorting problem.
Thanks again.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks for your help