Spotfire Ideas Portal
Add a new idea Subscribe
Status Implemented
Product Spotfire
Categories Custom Expressions
Created by Guest
Created on Nov 28, 2016

RELATED IDEAS

Manual Aggregation in Cross Table Grand Totals.

Hi,

If one of my column is calculating avg, in grand total I wanted to use sum of the above results as grand total. But, now it is calculating avg.

Implemented in 7.11
  • ADMIN RESPONSE
    Jan 18, 2019

    This feature was implemented in Spotfire 7.11

  • Attach files
  • Guest
    Reply
    |     Jan 17, 2019

    You can use a data function to get a manual aggregation! Use data.table TERR function.

  • Guest
    Reply
    |     Jan 17, 2019

    Thanks Fredrik. Unfortunately we are still on 7.8 :-(

  • Guest
    Reply
    |     Sep 13, 2018

    From version 7.11 you can do this!

    In the property pages, in the Totals tab below the 'Calculate totals' label you select the 'As the sum of cell values' radio button.

This document (including, without limitation, any product roadmap or statement of direction data) illustrates the planned testing, release and availability dates for Spotfire products and services. It is for informational purposes only and its contents are subject to change without notice. Planning to implement - generally 6-12 months out. Likely to Implement - generally means 12-18 months out. Copyright © 2014-2023 Cloud Software Group, Inc. All Rights Reserved. Cloud Software Group, Inc. ("Company") follows the EU Standard Contractual Clauses as per the Company's Data Processing Agreement. Terms of Use | Privacy Policy | Trademarks | Patents | Contact Us