Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Reporting summary from a hierarchical table

Hi All,

I have a sample table with hierarchy like:

PLAN NAMEPARENT 1CHILD 1POINTS
ABC  10
ABCABCP1ABCP1C15
DEF  15
DEFDEFP1DEFP1C125

 

The above hierarchy is like: "PLAN NAME=>PARENT 1=>CHILD 1=>POINTS"

 

There is one slicer in my report that contains "PLAN NAME" as selections. Now I want to get the "TOTAL POINTS" based upon the "PLAN NAME" selected in the slicer, but only for the top level hierarchy i.e., I want to total the points for selected plans which has no or blank "PARENT 1" value.

 

So, it is like I want TOTAL POINTS = 10 + 15 as highlighted above where I have selected both of these plans in the slicer i.e. ABC + DEF are selected, when I use my formula I get error something like multiple columns entries.

 

I believe this is quite easy but I can not figure it out the exact formula for this at the moment. Any easier and quicker formula to extract this would be nice.

 

Thanks for the help! 

Need Help
  • yakamoz007's avatar
    yakamoz007
    4 years ago

    Hi,

     

    u can use this formula

     

    Column = if('Table'[PARENT 1] ="", 'Table'[POINTS],0)

     

     

     

4 Replies

  • yakamoz007's avatar
    yakamoz007
    Icon for Helper I rankHelper I
    4 years ago

    Hi,

     

    u can use this formula

     

    Column = if('Table'[PARENT 1] ="", 'Table'[POINTS],0)

     

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Sorry, my mistake. Actually I was using wrongly named plan in the slicer and hence values were incorrect.

       

      The solution was simple as you specified and as I wrote earlier.

       

      Thanks.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      I did use this but this does not give me correct count. I need points for all the multiple selections from the slicer. 

      • yakamoz007's avatar
        yakamoz007
        Icon for Helper I rankHelper I
        4 years ago

        U have to make new columns where you put the same parent and child name. He is summarizing the rows. And your rows are splitting into blank or filled cell.

         

         

        This is the only way where I know that is working.  Or you delete the columns Parent and child.

        Maybe someone else knows a better way.