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] ) )
)
v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
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] ) )
)
jessicarocha's avatar
jessicarocha
Icon for Helper IV rankHelper IV
4 years ago

v-chuncz-msft 

Thank you for your reply. It also helped me. 
Would it be possible to keep these values fixed when the user uses the slicer to filter by "Svc Code" ? 
Because at the moment, in this case, the percentage becomes 100%.

Example: User filter per "CAP"

Current Result:

Eng PartnerSvc CodeFY18 YTD TER 
Smith, JaneCAP$17,409100%
Jones, JoeCAP$207,531100%


Desired Result:

Eng PartnerSvc CodeFY18 YTD TER 
Smith, JaneCAP$17,4094.66%
Jones, JoeCAP$207,53167.52%


Thank you so much in advance!

Kind regards, 
Jéssica