Monarch Classic Summaries

Janet_21505
Janet_21505 Altair Community Member
edited July 2019 in Community Q&A
I would like to add a count in my summary report.  If I add the measure "count" the summary displays "1"s and reports the total count in the subtotal line for the key "Class".  Is it possible to only report the count subtotal and not see the "1"s.  Hiding the count measure removes it from the summary, but I loose the count subtotal. 
Janet Grimsley
image


------------------------------
Janet Grimsley
VP, Business Intelligence
The Fauquier Bank
Warrenton VA
(540) 349-0215
------------------------------
Tagged:

Answers

  • Steve_Caiels
    Steve_Caiels
    Altair Employee
    edited July 2019
    Hi Janet,

    From a *visual* perspective, you can change the foreground and background colours to the same value.  They values will still be there, but will not be visible in Monarch or when printed to physical media or PDF.  (By the way, one of my counts is 2!)

    image


    They may or may not be visible in Excel, depending on versions and options.  I think they will always be visible in applications such as Access, MS SQL Server, csv etc.

    To set this up, edit the summary, select the Count measure, then navigate to the "Coloring and Limits" tab. 
    Select "Override for selected groups" and choose the correct level.
    image

    Edit the "Normal Values" and choose the same value for Text and Fill.

    Regards,
    Steve.




    ------------------------------
    Steve Caiels
    Professional Services
    Altair
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 07-16-2019 03:38 PM
    From: Janet Grimsley
    Subject: Monarch Classic Summaries

    I would like to add a count in my summary report.  If I add the measure "count" the summary displays "1"s and reports the total count in the subtotal line for the key "Class".  Is it possible to only report the count subtotal and not see the "1"s.  Hiding the count measure removes it from the summary, but I loose the count subtotal.
    Janet Grimsley
    image


    ------------------------------
    Janet Grimsley
    VP, Business Intelligence
    The Fauquier Bank
    Warrenton VA
    (540) 349-0215
    ------------------------------
    "
  • Janet_21505
    Janet_21505 Altair Community Member
    edited July 2019
    Steve Caiels_21881 said:

    Hi Janet,

    From a *visual* perspective, you can change the foreground and background colours to the same value.  They values will still be there, but will not be visible in Monarch or when printed to physical media or PDF.  (By the way, one of my counts is 2!)

    image


    They may or may not be visible in Excel, depending on versions and options.  I think they will always be visible in applications such as Access, MS SQL Server, csv etc.

    To set this up, edit the summary, select the Count measure, then navigate to the "Coloring and Limits" tab. 
    Select "Override for selected groups" and choose the correct level.
    image

    Edit the "Normal Values" and choose the same value for Text and Fill.

    Regards,
    Steve.




    ------------------------------
    Steve Caiels
    Professional Services
    Altair
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 07-16-2019 03:38 PM
    From: Janet Grimsley
    Subject: Monarch Classic Summaries

    I would like to add a count in my summary report.  If I add the measure "count" the summary displays "1"s and reports the total count in the subtotal line for the key "Class".  Is it possible to only report the count subtotal and not see the "1"s.  Hiding the count measure removes it from the summary, but I loose the count subtotal.
    Janet Grimsley
    image


    ------------------------------
    Janet Grimsley
    VP, Business Intelligence
    The Fauquier Bank
    Warrenton VA
    (540) 349-0215
    ------------------------------
    "

    I should have thought of that.......Thanks, Steve!

     

     

    Thank you,

    Janet

     

     

     



    ------Original Message------

    Hi Janet,

    From a *visual* perspective, you can change the foreground and background colours to the same value.  They values will still be there, but will not be visible in Monarch or when printed to physical media or PDF.  (By the way, one of my counts is 2!)

    image


    They may or may not be visible in Excel, depending on versions and options.  I think they will always be visible in applications such as Access, MS SQL Server, csv etc.

    To set this up, edit the summary, select the Count measure, then navigate to the "Coloring and Limits" tab. 
    Select "Override for selected groups" and choose the correct level.
    image

    Edit the "Normal Values" and choose the same value for Text and Fill.

    Regards,
    Steve.




    ------------------------------
    Steve Caiels
    Professional Services
    Altair
    ------------------------------
    "
  • Mahmoud
    Mahmoud
    Altair Employee
    edited July 2019
    Hi Janet,
    The way your summary is configured, you may try changing the count column color to white (see screenshot below, Coloring and limits)
    image

    I had one of your reports and model, and tried it, and it worked.
    image
    Regards
    Mo

    ------------------------------
    Mahmoud Abdolrahim
    Senior Implementation & Integration Engineer
    Datawatch Corporation
    MA
    (978) 935-3840
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 07-16-2019 03:38 PM
    From: Janet Grimsley
    Subject: Monarch Classic Summaries

    I would like to add a count in my summary report.  If I add the measure "count" the summary displays "1"s and reports the total count in the subtotal line for the key "Class".  Is it possible to only report the count subtotal and not see the "1"s.  Hiding the count measure removes it from the summary, but I loose the count subtotal.
    Janet Grimsley
    image


    ------------------------------
    Janet Grimsley
    VP, Business Intelligence
    The Fauquier Bank
    Warrenton VA
    (540) 349-0215
    ------------------------------
    "
  • Janet_21505
    Janet_21505 Altair Community Member
    edited July 2019
    Mahmoud said:

    Hi Janet,
    The way your summary is configured, you may try changing the count column color to white (see screenshot below, Coloring and limits)

    image

    I had one of your reports and model, and tried it, and it worked.
    image
    Regards
    Mo

    ------------------------------
    Mahmoud Abdolrahim
    Senior Implementation & Integration Engineer
    Datawatch Corporation
    MA
    (978) 935-3840
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 07-16-2019 03:38 PM
    From: Janet Grimsley
    Subject: Monarch Classic Summaries

    I would like to add a count in my summary report.  If I add the measure "count" the summary displays "1"s and reports the total count in the subtotal line for the key "Class".  Is it possible to only report the count subtotal and not see the "1"s.  Hiding the count measure removes it from the summary, but I loose the count subtotal.
    Janet Grimsley
    image


    ------------------------------
    Janet Grimsley
    VP, Business Intelligence
    The Fauquier Bank
    Warrenton VA
    (540) 349-0215
    ------------------------------
    "
    Thanks Mo.  This is an easy solution that I should have come up with.

    ------------------------------
    Janet Grimsley
    VP, Business Intelligence
    The Fauquier Bank
    Warrenton VA
    (540) 349-0215
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 07-17-2019 08:12 AM
    From: Mahmoud Abdolrahim
    Subject: Monarch Classic Summaries

    Hi Janet,
    The way your summary is configured, you may try changing the count column color to white (see screenshot below, Coloring and limits)
    image

    I had one of your reports and model, and tried it, and it worked.
    image
    Regards
    Mo

    ------------------------------
    Mahmoud Abdolrahim
    Senior Implementation & Integration Engineer
    Datawatch Corporation
    MA
    (978) 935-3840
    ------------------------------

    Original Message:
    Sent: 07-16-2019 03:38 PM
    From: Janet Grimsley
    Subject: Monarch Classic Summaries

    I would like to add a count in my summary report.  If I add the measure "count" the summary displays "1"s and reports the total count in the subtotal line for the key "Class".  Is it possible to only report the count subtotal and not see the "1"s.  Hiding the count measure removes it from the summary, but I loose the count subtotal.
    Janet Grimsley
    image


    ------------------------------
    Janet Grimsley
    VP, Business Intelligence
    The Fauquier Bank
    Warrenton VA
    (540) 349-0215
    ------------------------------
    "

Categories