This content has been marked as final.
Show 5 replies
-
1. Re: Filter Null values and Measure names
Zhouyi ZhangJan 31, 2019 4:05 AM (in response to Karthik Suresh)
Hi, Karthik
Please find my solution attached.
Below is steps:
1st, pivot your data
2nd, build the view as below
Hope this helps
ZZ
-
Book1_v10.2.twbx 15.4 KB
-
-
2. Re: Filter Null values and Measure names
Karthik Suresh Jan 31, 2019 4:57 AM (in response to Zhouyi Zhang)Hi Zhouyi,
I am trying to use your solution, When i create a pivot with these values i have a column which says Pivot values and Pivot names , Which one should I use to create the view, the measure values or the pivot values?
Regards
Karthik Suresh
-
3. Re: Filter Null values and Measure names
Zhouyi ZhangJan 31, 2019 5:09 AM (in response to Karthik Suresh)
Hi, Karthik
my bad. I did a rename of pivot names to MeasureName and pivot value to MeasureValue shown in my view.
so just use the "Pivot Name" to replace the 'MeasureName' and 'Pivot Value' to replace the 'MeasureValue' in my sample.
Please let me know if you have further quesiton.
ZZ
-
4. Re: Filter Null values and Measure names
Karthik Suresh Jan 31, 2019 5:19 AM (in response to Zhouyi Zhang)Hi Zhouyi,
Works perfectly!!! Thanks!!!!!
Regards
Karthik Suresh
-
5. Re: Filter Null values and Measure names
Zhouyi ZhangJan 31, 2019 5:20 AM (in response to Karthik Suresh)
you are welcome
ZZ