If grand totals are turned off, and the aggregated measures are above other dimensions in the column or row, then the subtotal columns for the measures will not be displayed regardless of whether subtotals are turned on or not. Once grand totals are turned on, they are displayed above the grand total columns for each measure.
This can be seen in the following fiddle: http://jsfiddle.net/gx19nf3k/
Ideally, the headers would have the same structure when you swap “country” and “values” in the column hierarchy, looking the same as http://jsfiddle.net/Lvwcrg6m/ but with “Sum of Price” swapped with “Canada” and “Sum of Quantity” swapped with “USA.”
On a side note (this doesn’t affect us because we don’t want grand totals), when grand totals are turned on in this scenario, the grand total columns are seemingly duplicated with one at each measure column and one at the end under a “grand total” section. I assume that is not what other users would want, but as I said, that doesn’t affect us. http://jsfiddle.net/9tq5uqLx/ is what I’m talking about. I can see that it might be valuable if the measures were in the middle of the hierarchy, but when they are at the top, it seems unnecessary.
Thank you for providing us with the detailed description of the issue when grand totals are turned off. It will be fixed in the minor release 2.323 (ETA – Aug 28). By that time the major version 2.4 will be released and this fix will be available there as well. Does this work for you?
Also, thank you for the note about the “grand total” section that seems unnecessary when the measures are at the top. The “grand total” section can be turned off for columns using options. But we will definitely discuss your comment internally with the team.
Please let me know if you have any further questions.
This is a common use-case for us, so I do wish it could be fixed sooner. I suppose in the meantime we can either include grandTotals and then use a cell customize function to hide them or do the reverse and use a cell customize function to manually show them. If you happen to know of any easier workarounds off the top of your head, let me know.
Thank you for your feedback. Our development team will speed up the process of fixing the issue. The fix will be delivered as part of our next minor release 2.322 (ETA – Aug 14). We will inform you as soon as the fix is ready.
Thanks so much!
I am glad to inform you that your fix is ready both for the minor release 2.322 and for the major 2.4 which are available for download now.
You are welcome to update the component.
I work with Jaime and it seems the problem is not completely resolved. We wanted to turn off the subtotals by default and now it seems the sub totals would always appear.
Flex monster config:
grand totals: off
sub totals: off
Measures reported as first thing in the columns
With these settings it seems the sub totals are always present irrespective of what settings are chosen.
Thank you for providing us with the details of the issue.
I have created a sample that illustrates it: http://jsfiddle.net/flexmonster/3ys7Lrh6/
The component can be updated the way that when subtotals are turned off the highlighted cells will be empty (please see the image attached), but the structure of the table will remain the same.
Please let us know if it works for you and we will provide you with the ETA.
I think thats fine for now. But could you please confirm if there are multiple attributes in the column then all the columns except the lowermost granularity expanded would be blank when subtotals is off?
Please find the attached screenshot with highlighted cells which I am thinking would be blank after your fix.
Also can you take this as a feature request where you would not display the blank cells too ?
Thank you for providing the screenshot. I can confirm that if there are multiple attributes in the column then all the expanded columns would be blank when subtotals are off. Please note that if they are collapsed (not expanded), then numbers would be shown even if subtotals are off. Please see the screenshot attached.
Will this work for you? If yes, the fix will be included in the minor versions 2.323 and 2.402 (ETA – Aug 28).
We have added your feature request to not display the blank cells to our backlog, but there is no ETA for this feature.
Hi, that sounds good for not showing subtotals when they are turned off, however there is an additional and perhaps worse bug that when you first load the page, even with the latest versions, the subtotals row is missing and so are the measure captions.
Please see the following: http://jsfiddle.net/gx19nf3k/4/
It fixes itself when you turn subtotals on and off again. It will also occur if you drag the values above other columns at any point.
Thank you for reporting this additional issue. The fix will be provided in the minor versions 2.323 and 2.402, ETA Aug 28. As a workaround, we suggest defining
showGrandTotals the same way as in our documentation:
showGrandTotals – String. Specifies how to show grand totals: in rows (
"rows"), in columns (
"columns"), in rows and columns (
"on" ) or hide them (
"off" ). Default value is
Does it work for you?
I am glad to inform you that the minor release 2.323 and 2.402 are ready for download now.
The fix for the issue with the subtotals turning off when the measures are above other dimensions in columns or rows is already available there.
The fix for the issue with boolean values for `options.grid.showGrandTotals` will be released in the next minor releases 2.324 and 2.403 ETA Sep11.
I am glad to inform you that the minor releases 2.324 and 2.403 are available for download now. The issue with boolean values for
options.grid.showGrandTotals was fixed.
You are welcome to update the component.