Forum Discussion

nailed's avatar
nailed
Frequent Visitor
4 years ago
Solved

Count GROUP BY Manager Level

Hi Eryone,

 

I'm really having a hard time with this issue, can I make the accumulated number of targets from each team go to the top level? Using GROUP By or something else? This is also related to the number of sales per team leader or per regional leader.

 

 

What I want is to add up the targets/sales per leader, per senior leader, to the regional leader.

Can you help me to solve this problem?

 

Thank you

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    4 years ago

    nailed sure, just create a card visual on the same page.  By default, clicking on a level in the matrix will also filter the card (cross-filtering interaction).

     

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    nailed can you just create a Matrix visual, and add Regional Leader ID, Senior Team Leader ID, and Team Leader ID to the "Rows"?

    See below example with dummy data.

     

    • nailed's avatar
      nailed
      Frequent Visitor
      4 years ago

      Okay, thank you Anonymous . And is it possible for me to create a visualization card of the target when I click/select per level?

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        nailed sure, just create a card visual on the same page.  By default, clicking on a level in the matrix will also filter the card (cross-filtering interaction).

         

  • smpa01's avatar
    smpa01
    Icon for Community Champion rankCommunity Champion
    4 years ago

    nailed  provide a samll sample data and expected output based on the data.

     

    upload a sample pbix in 1/g drive and share the link here

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi nailed ,

     

    Whether the advice given by Anonymous  has solved your confusion. If it has been solved, you can mark the correct response as the standard answer to help the other members find it more quickly. If not, please point it out.


    Looking forward to your feedback.


    Best Regards,
    Henry