How can I hide specified value fields and displays only in subtotal

Posted by: sulmar on 9 September 2017, 8:28 am EST

  • Posted 9 September 2017, 8:28 am EST

    I would like to customize C1 Olap Grid for my customer.

    Row Fields: Product
    Column Fields: Year
    Values: Amount (Sum), Quantity (Sum)
    Total Columns: subtotal checked

    I would like to hide Quantity in value fields and displays only in subtotal.

    Example:
    | 2009 | 2010 | 2011 |
    | Q1 | Q2 | Q3 | Q4 | subtotal |
    | amount | amount | amount | amount | amount | quantity |
    Product 1 | 100 | 50 | 50 | 200 | 400 | 20 |
    Product 2 | 200 | 50 | 50 | 50 | 350 | 120 |




    How Can I do it?
  • Replied 9 September 2017, 8:28 am EST

    Hello Sulmar,

    Would you be able to post a screenshot of the OLAP grid that includes the fields that you want to modify? I am having trouble visualizing what you need from your illustration.

    Regards,
    Justin
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels