Fade Out "Grand Total" for structured DataViews

Options
Previous Member
Previous Member
5 Up Votes First Comment 5 Likes First Anniversary
in Platform

We are using a lot of structured data views and in most cases, the grand total line isn't usefull for us.

 

Is this feature planned for the future?

Answers

  • Etienne CAUSSE
    Etienne CAUSSE Customer
    First Anniversary Advocate Community Voices Name Dropper
    Options

    Hi,

    I find myself very often in the situation where I'd also like to hide the grand total while keeping the intermediate downtotals.

    I opened a ticket #21234 in October 2016 for this, but still no answer.

  • Gabriele Gallo
    Gabriele Gallo Employee
    Level 100: Foundations of Building in Board Community Voices First Anniversary First Comment
    edited March 2020
    Options

    Hi Paul Stegmann, hi Etienne CAUSSE

    i think there is no such option in BOARD as of today.

    What's possible though is to remove all downtotals from the Rows (which will also remove the grand total).

    image

    Another option could be to format the grand total line in such a way that it is "not visible" using dataview formatting options for grand total and borders.

     

    image

     

    I hope this helps you find a solution for your case.

    If this is a feature you feel should be in a future release please feel free to submit an idea in the Ideas section

     

    Ciao,

  • Etienne CAUSSE
    Etienne CAUSSE Customer
    First Anniversary Advocate Community Voices Name Dropper
    Options

    Hi Gabriele,

    Your Board colleagues mentioned these two solutions already but they're not completely satisfying. For example in a case I had a layout where I needed to present a hierarchy of Items, with several columns (actual, budget...) and where the top item of the hierarchy needed its total displayed. However I cannot do that without downtotals.

    Therefore I activated downtotals and formatted the grand total to be invisible.

    BUT the issue was that on some columns I had an alert (green/red for growth indicator) and this alert became visible also on the grand total, which made the result ugly.

     

    I'll post this in Ideas

  • Unknown
    Unknown
    edited March 2020
    Options

    Hello Etienne,

     

    in your case the solution could be to add a block Entity with the entity at the deepest level by Row, and one algorithm for each block with alert. Then, in the algorithm you have a condition that is true only for the Total.

     

    For example, if I have Year and Month by Row and I know my Time Range contains 10 years, I can set the following:

    - Block (a): Cube (without Alert) - Hidden

    - Block (b): Entity [Month] - Hidden (shown in my screenshot just for better understanding)

    - Block (c): Algorithm [if(AND(b>12,b<=120),0,a)] + Alert + Summary Algorithm "Calculated"

     

    You apply the formatting suggested by Gabriele to make invisible the Grand Total and you get the Alert not to show up on the Grand Total. See below for two dataviews with the original case (left side with alert appearing on the Total) and the application of my suggestion (right side).

    The tricky point is to find a valid condition in the algorithm: if you want that to be covering all possible selections, I don't exclude it can be hard.

    image

    Regards

    Davide

  • Etienne CAUSSE
    Etienne CAUSSE Customer
    First Anniversary Advocate Community Voices Name Dropper
    Options

    Hi Davide,

    Thanks for your suggestion, I'll have a look and try to find the appropriate algorithms. Indeed in my layouts it seems a bit tricky. Moreover we need to think about the users who might want to configure the layout themselves and add an Entity by row, in that case the trick is not usable. This case is really important for us since version 10.1 added the "configure layout" in web.

Categories