Skip to main content
Question

Pivot table removing unwanted values

  • October 6, 2020
  • 2 replies
  • 5 views

Hi Team,

Am trying to find out , country wise how many billing blocked customers and delivery blocked customers I think i did it, but how do i remove the zeros from the pivot table.

image940425 14.6 KB

If i expand the country, i required only the KPIs Dimension. not the unwanted values (refer the below screen shot). Thanks in advance.

image977439 28 KB

2 replies

  • Level 0
  • November 22, 2021

Hi @prakash.k14,

 

unfortunately, I can not find a screenshot attached. Could you please re-share it?

I would suggest to simply add a component filter. If that does not suit your requirement, feel free to share some more details!

 

Best,

 

Justin


  • Author
  • Level 3
  • November 23, 2021

Hi @prakash.k14,

 

unfortunately, I can not find a screenshot attached. Could you please re-share it?

I would suggest to simply add a component filter. If that does not suit your requirement, feel free to share some more details!

 

Best,

 

Justin

Hi @justin.stegm , Thanks for your reply.. I think i have done that by me some time back , yes.. Did it in the way you suggested in the above mail only i guess.. Thanks for your reply once again..