table of totals?

[becki_kain]

i have a pivot table, as shown below, and i broke up the very complex equations to individual columns then put them together, as shown below.  I had to do this as a pivot table to get the subtotals (the column where "Car" will have "utility" and "truck" later on).  the problem is with the pivot table, i can't hide the pieces of the equations so the final columns will be these massive and unweildy equations.  if i break up the charts into line charts of "car" "utility" and "truck, i can get the subtotals of each but how do i add those subtotals to get the final line of totals (and the bottom of this chart)?  thanks

becki kain

[MK9885]

add all the expressions?

[becki_kain]

I need the totals running across the bottom row, not as an expression. thanks

[MK9885]

Aren't the totals in the bottom?

Can you explain clearly what you looking for?

[Anonymous]

I'm not exactly sure what you're trying to do.  Can you mock up what you want it to look like?

[becki_kain]

I want, in alteryx, to break up the data, by vehicle type, then make a line chart for each, not pivot chart, so I can hide all the extra expressions but then add up all the "total" lines, at the bottom, like it's done in the picture  you showed

or, how do you do subtotals without doing a pivot table?  thanks

[becki_kain]

Industry
(%)
Small B Car	3.0
Small C Car	13.2
Medium Car	9.8
Large Car	1.4
Sports	1.3
Small B/C Premium	0.6
Medium Premium	2.8
Large Premium	1.2
F/Sports Premium	0.6
CAR	34.2

then the truck one, then the utility one, then a row of totals from all 3 charts

[Anonymous]

Try this attachment. 

If that still isn't what you're looking for try:

Is there a way to show partial totals in straig... | Qlik Community

[becki_kain]

that's still a pivot table so I can't hide expressions.  thanks

[Anonymous]

What are you trying to hide?  The way I changed it, each column is independent.  So you would just remove the columns you don't want to see.