Subtotals in straight table

[sebdupont]

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 ?

[Arthur_Fong · Accepted solution]

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

[sebdupont]

Thanks Arthur, your simple example help me to understand where i was wrong

A simple column sorting problem.

Thanks again.

[sugathirajkumar]

sort->Region->Numeric VAlue->Decending

[sugathirajkumar]

[sebdupont]

Thanks for your help