Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
sagnikrana
Partner - Contributor II
Partner - Contributor II

Removing selected rows from pivot table

Hello Everyone,

Can anyone help me to remove few of the rows from the pivot table ? The table looks like this:

 

Screen Shot 2020-04-06 at 3.45.28 PM.png

 

I want to remove all the rows from the measure which has "There are no further subtasks" for the selected item.

Appreciate your time!

 

Thanks,

Sagnik

 

Labels (1)
  • Chart

1 Reply
Anil_Babu_Samineni

You need to write dimension like

If(name2<>'There are no further subtasks', name2)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful