Forum Discussion

hkrash0920's avatar
hkrash0920
Icon for Helper I rankHelper I
8 years ago
Solved

Subtotal Percentages

Hi...I am trying to get the percentage of sub totals. See the below Excel file. For example for Jane Smith, we have percentages for CAP, RD, RER, and S199 which shows the percentage that CAP is compa...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    hkrash0920,

     

    You may add a measure as shown below.

    Measure =
DIVIDE (
    SUM ( Table1[FY18 YTD TER] ),
    CALCULATE ( SUM ( Table1[FY18 YTD TER] ), ALLSELECTED ( Table1[Svc Code] ) )
)
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Dear hkrash0920,

 

Incase of keeping the original Value, just clone new measure column and using using "Show value as > Percent of column Total".

 

 

 

 

Regards,

ManNVSM.