IBM Business Analytics

 View Only
Back to discussions
Expand all | Collapse all

How to sum up by category or section in Crosstab

  • 1.  How to sum up by category or section in Crosstab

    Posted Fri April 14, 2023 02:45 PM

    I have crosstab table includes main group and subgroup, and subgroups includes items. 
    I want to add a calculated column to have the percentages of each item inside every subgroup to be the total percentage for each subgroup is 100%
    I used different functions but all of them give the percentage of each item for the main group.

    [Value]/
    Total([Value] within set [AUDIT_COLUMN_2])

    [Value]/Total([Value]for report)


     



    ------------------------------
    F Yousef
    ------------------------------


Related Content