Display subtotals in a table

#1

Hello,
I have a table with subtotals by customer and totals by items. But only I can see subtotal by customer when Ii is selected the year. However, when I open the year by quarter or month, I can’t see subtotal.
Here displays the year subtotal by customer and it is good:

pict1
pict1.png829×366 15.5 KB

However, when I open the year to see by quarter or month, the subtotals don’t have information:

pict2
pict2.png1203×368 19.4 KB

pict3
pict3.png1215×413 15.4 KB

This is the data analyst panel:

pict4
pict4.PNG601×891 57.1 KB

Thank you in advance,

#2

Hi,

I could not replicate this with a similar setup in V10. A couple of questions:

  • Which version are you on?

  • What happens if you right click and ‘change level’ to Month instead of expanding manually?

  • Do you have any custom total calculations in this table? If yes, get rid of them and verify if that solves the problem

  • Also, revisualize this to a new table (this will reinstate the default settings of a table) and see if the problem persists

Let us know.

#3

Thanks Upasana:

  • Which version are you on? 10.0.0.1006-w
  • What happens if you right click and ‘change level’ to Month instead of expanding manually? Works well but is not possible compare this month with other months in the same screen.
    pict5
  • Do you have any custom total calculations in this table? If yes, get rid of them and verify if that solves the problem. No, I don’t have any custom total calculation.
  • Also, revisualize this to a new table (this will reinstate the default settings of a table) and see if the problem persists. I just made it but the problem persists when I checked “Collapse All” box in these 2 fields “Customer name” and “Item”:
    pict6
    pict6.PNG695×827 43.2 KB

I will appreciate your help,
Thanks,

#4

Hi, somebody could help me?

#5

Hi Jorge,

Have you tried to duplicate the date field in your query and use one for the filter (not shown in the visualization) and the other as column (shown in the visualization)? Because for me it sounds like the sum is only made for the date that is set in the filter because the column is linked directly to the filter.
It’s just an idea…

1 Like
#6

Hi Jorge,

I am not sure what is going on because I could not replicate it. Can you please contact Dundas Support so that we can have a better look?

1 Like
#7

I will do, thank you Upasana.