Need a special offer?Find out if your project fits.
+

How to hide subtotals columns when showSubtotal is set to false?

Answered
Gabriele Tagliazucchi asked on December 6, 2018

Hi,
we've identified Flex as the main candidate pivot component for a web site, but client is not convinced becaus of this limitation: it seems impossible to hide the column subtotals. Setting Options "do not show subtotals", still shows (empty) columns. Is there a way out of this?
 
Thanks,
G.

13 answers

Public
Tanya Gryshko Tanya Gryshko Flexmonster December 6, 2018

Hello, Gabriele,
Thank you for your interest in Flexmonster Pivot.
Currently, our сlassic view option is available for row headers only. Column headers are displayed in a compact form, that is why you see the empty columns. The request for such improvement is in our backlog. However, there is no estimated timeframe.
Please let me know in case of any other questions.
Regards,
Tanya

Public
Jon January 3, 2019

Hi,
Has there been any further discussion on this? A couple of fellow team members and clients were excited about the ability to easily hide subtotals, but were a little crestfallen to learn that the empty columns still show up. Is there a Javascript or CSS workaround that we could use for now?
Thanks,
Jon

Public
Dmytro Zvazhii Dmytro Zvazhii Flexmonster January 8, 2019

Hello Jon,
Thank you for writing. Currently, the architecture of our Pivot Table does not allow to avoid the empty columns. The empty columns which appear after the subtotals are turned off are in charge of expand/collapse functionality. Therefore, it is not possible to find an external Javascript or CSS workaround.
The only solution is to reconsider the current design and find a better approach. As my colleague Tanya has already mentioned, such task is already in our backlog. However, due to its complexness, we are not ready to provide you with the estimated timeframe.
Please let us know in case of any other questions.
Regards,
Dmytro

Public
Munir April 22, 2019

Hello, 
Any progress on this request? It's very hard to explain to clients the reason of these empty columns.
Thanks

Attachments:
chrome_ChU5WHTR2h.png

Public
Vera Didenko Vera Didenko Flexmonster April 23, 2019

Hello, Munir,
 
Thank you for your question.
 
We would like to point out that the request has been added to our customers' wishlist.
Please note, however, that our roadmap is full at the moment and this feature is not in the top list of pending requests. 
 
We will inform you in case of any updates concerning this request.
 
Please let us know if you have further questions.
 
Best Regards,
Vera

Public
FERNANDO GUZMAN May 2, 2019

Hi, 
I have the same request, we have another pivot in legacy versions that has the feature and is being missed in our solutions with FlexMonster.   The argument from business is "In some cases the column totals don't make sense'

Public
Tanya Gryshko Tanya Gryshko Flexmonster May 3, 2019

Hello, Fernando,
Thank you for writing to us.

We have added your company to this feature request inside our customers’ wish list.

Our team will get back to you if we have any updates on the subject.

Please let us know if you have any other questions.

Regards,
Tanya

Public
Dmytro Zvazhii Dmytro Zvazhii Flexmonster May 21, 2019

Hello,
We have good news regarding the issue with blank columns.
Here is the beta version: https://s3.amazonaws.com/flexmonster/FLEXMONSTER-2_7_7-beta-MAY16.ZIP.
Could you please check if it meets your needs?
Please keep in mind that it is a beta version and still requires more efforts for testing. It will appear in the release build not earlier than the 3rd of June.
We would be grateful for your feedback.
Regards,
Dmytro

Public
Jon May 28, 2019

Hi there,
The initial beta version looks awesome!
The only thing I noticed was that as I put my own project's custom options on the example, specifically "expands": { "expandAll": true } (single change shown in attached png) onto the data Slice, there seems to be weird behavior when then trying to expand/collapse columns in the grid (some headers/parent hierarchies disappear, expand/collapse button becomes inoperable after clicking it the first time).
Hope this helps! I can't wait to implement this into our app as its something our clients have been requesting!
Sincerely,
Jon

Public
Tanya Gryshko Tanya Gryshko Flexmonster May 30, 2019

Hello, Jon,

Thank you for your reply. Your feedback is very important to us.

Our team will look into it in more detail shortly and we will notify when we have the results.

Please contact us in case of any questions.

Regards,
Tanya

Public
Vera Didenko Vera Didenko Flexmonster June 19, 2019

Hello, 

We are glad to announce that the issue with blank columns was fixed for the grid with showTotals turned off.

This is available in the 2.7.8 version of Flexmonster: https://www.flexmonster.com/release-notes/
You are welcome to update the component: https://www.flexmonster.com/doc/updating-to-the-latest-version/

Please let us know if everything works fine.
We are looking forward to hearing from you.

Best Regards,
Vera

Public
James July 16, 2019

Hi Vera,
Is there a plan for this fix to be applied to webdatarocks?
Thanks,
James

Public
Vera Didenko Vera Didenko Flexmonster July 17, 2019

Hello, James,
 
We kindly request to ask questions regarding WebDataRocks on the WebDataRocks forum.
 
You are welcome to contact us there.
 
Best Regards,
Vera

Please login or Register to Submit Answer