Pivot Subtotals Missing

Toad Data Point & Toad Intelligence Central
1

Running TDP workbook 5.05.61, ran into an issue with missing subtotals:

subtotals%20missing
subtotals missing.jpg760×363 55.7 KB

2

Let me have someone look into this.

3

Hi Steve,

We don't support subtotal Rows/Column combination (subtotal of subtotal). In your example it could make sense but this is not common situation and in other cases it would be really confusing.

image
image.png906×289 11.1 KB

As you can see on my example - there should be 2 values = 40 or 45.

4

Hi Filip, in your example the subtotal should be 40. The 5 from TEXT value 1 would not be included:

subotals%20missing%20%232
subotals missing #2.jpg902×288 43.9 KB

5

Any updates on this issue? Populating the missing subtotals seems straightforward to me, can't think of any situation where it would be confusing.

6

Yes, QAT-14989 is created to support calculation for subtotals.

7

Do you have an estimate date when this issue will be corrected?

8

It is still in the queue to be reviewed and schedule. I will give it a "nudge" :running_man:

9

Hi @steve.robinson,
unfortunately we will not be able to implement this enhancement because the component we use cannot support it.
dan