Select which Sub-totals to show in Table charts

user02412

It would be helpful if we could choose for which fields we want to show sub-totals. 

 

For example, I have a table in which the columns are split into Years, then into Quarters, and then into Projects. When I choose to show sub-totals, it aggregates the Projects in each Quarter, and it also aggregates the Quarters in each Year. This makes the table extremely long. 

 

I would like to show only the sub-total that aggreagates the Quarters in each Year (i.e. leaving out the sum of Projects in each Quarter). 

SLaczny

I would add that controlling which rows o subtotal would be nice. I have a table where we have 6 account managers, but only 2 of them have assistants. I would like to see subtotals for only those that have assistants, than see 2 rows for those who dont.

 

Something like this:

mstorne

Did you find a solution for creating custom subtotals?

 

Thanks,

Marko.

---

@user02412 wrote:

It would be helpful if we could choose for which fields we want to show sub-totals. 

 

For example, I have a table in which the columns are split into Years, then into Quarters, and then into Projects. When I choose to show sub-totals, it aggregates the Projects in each Quarter, and it also aggregates the Quarters in each Year. This makes the table extremely long. 

 

I would like to show only the sub-total that aggreagates the Quarters in each Year (i.e. leaving out the sum of Projects in each Quarter). 

---