How to Total Weighted Score on Pivot

Comments

3 comments

  • Avatar
    Gowtham Senthilkumar

    Kahel, 

    Go to the menu of the Value "Total Weighted Score" and select "SubTotals By" and then select 'Sum'

     

    Thanks, 

    Gowtham Senthilkumar

    BI Consultant

    1
    Comment actions Permalink
  • Avatar
    John Ami

    Hi Gowtham,

    Thanks for your reply, I did the same thing, unfortunately when I remove the account from the selectionm so that I can only display weighted score per region. I'm still getting the same thing the weighted score displayed should be 1.72

    0
    Comment actions Permalink
  • Avatar
    Gowtham Senthilkumar

    Kahel, 

    The approach that I suggested works only when Account is there and you want the value on the Sub-total or Grand total. 

    For your use case, try something like this: 

    SUM([Account],[Weighted Score Regional Level]) -> here [Account] has the context of 'All Items' 

     

    Thanks, 

    Gowtham Senthilkumar

    1
    Comment actions Permalink

Please sign in to leave a comment.