Skip to Main Content
Spotfire Ideas Portal

Use different expressions for Grand total and Sub total from the columns

Customer would like to have the ability to apply logic to the subtotal(s) and grand total(s) so it do different things compare to how the content is calculated in a Cross Table visualization.
For example, can I have my content calculated by Avg(Something) but for my grand total, I do Sum(Calculated Column) instead of Avg(Calculated Column)

  • Attach files
      Drop here to upload
    • Guest
      Reply
      |
      Jul 6, 2016

      Our users often want both a SUM total and AVG total, would be nice if they could have control to have multiple Grand Totals and choose the aggregation type. So Grand Aggregations, I suppose.

    2 MERGED

    More filter options for subtotals

    Basically want to see a subtotal but for particular rows. Spotfire allows selection for subtotals for columns but then applies them in absolute fashion depending on y-axis hierarchy. Wish subtotals and grand totals had options for expression build...
    almost 8 years ago in Spotfire / Visualization 0 Future Consideration
    4 MERGED

    Cross tables: Make statistical measure for the subtotals and grand totals selectable

    I am analysing experimental data, and sums are useless there. However, maximum or average, median, minimum values come up frequently. To display those in cross tables, I put them in normal cells. However, it would be convenient if those could be d...
    almost 6 years ago in Spotfire / Visualization 1 Future Consideration