Is there a way to show partial totals in straight table

[#1]

Hi,

I have had to change one of my charts from a pivot to a straight table due to sorting restrictins.

Is there a way to show partial totals in a straight table similar to a pivot chart?

I need to show totals per customer.

Thanks,

Gregg

[Anonymous]

Hi

     Properties -->Expression --->Total Mode --> select expr total / No rows

   Regards

Ashok

[#3]

Hi chandashok

I tried this but no joy.

What I need is to show totals per customer (sub totals)

Thanks,

Gregg

[#4]

Hi Gregg,

Once you show the subgroup in straight table, the same
sorting issue will pop up again…

FYI:

Please find very simplistic solution of sub-totals in straight table

It may be possible to fix/modify sorting code in Pivot table, share sample data and should be advise or help

Regards

Kulbir

[#5]

Hi,

Im new to Qlikview so I will need to check through the sample data.

Thanks,

Gregg

[#6 · Accepted solution]

If your customer identifier field is named Cust and you want a subtotal of a field named invoice_amt then try adding an expression to your straight table chart like   =sum(total <Cust> invoice_amt)

[swuehl]

Not sure if I understand your needs, I think since QV11, you can add subtotals in dimension limits tab, check 'Show Total' for the appropriate dimensions.

Hope this helps,

Stefan

[#8]

Hi Tim,

how would that work, if my "invoice_amt" is not a "field" but a calculated field?? How would the solution look like then! Best thanks in advance.

Chris