Reporting summary from a hierarchical table

[Anonymous]

Hi All,

I have a sample table with hierarchy like:

PLAN NAME	PARENT 1	CHILD 1	POINTS
ABC			10
ABC	ABCP1	ABCP1C1	5
DEF			15
DEF	DEFP1	DEFP1C1	25

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! 

[yakamoz007 · Accepted solution]

Hi,

u can use this formula

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

---

[Anonymous]

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]

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

[yakamoz007]

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.