Need help with dimension/field (creating a subtotal value)

[Anonymous]

Hi y'all, I wanted to see if anyone has any suggestions to create a subtotal value in a dimension for a straight table. It would look almost like a hierarchy.

Here is the Dimension I currently have:

	Sum(Quantity)
Broccoli	5
Apple	1
Grapes	2
Strawberry	3

And here is what is requested:

	Sum(Quantity)
Vegetables	5
Broccoli	5
Fruit	6
Apple	1
Grapes	2
Strawberry	3

Any help or ideas would be appreciated, Thanks!

[its_anandrjs]

You can do this on any of the Straight table by make some changes and it is available to you please read the attched thread for this it is used in financial application.

How to Create a Profit and Loss Statement in QlikView

[vinieme12]

or this may be

Partial Sums in straight table | Custom Labels in Pivot SubTotals

[Frank_Hartmann · Accepted solution]

see attached sample

[Anonymous]

Thanks so much for the link, it looks like a great example.

[Anonymous]

Very interesting approach, I appreciate the help

[Anonymous]

Thanks Frank, this is pretty much what I was looking for so I appreciate the support!