Skip to main content

I build a simple table, comparing CY vs PY, as seen in pic below

I want to hide the empty rows "Difference 2018" and "% Difference 2018" while keeping "Sales.Total 2018" in the view.

How can i do that?

 

Hiding specific measures

 

t1.PNG

 

Message was edited by: Yeok Song Ng

3 risposte
  1. 11 giu 2018, 11:23

    Hi Yeok,

     

    Bring your two table calculations in the filters shelf and exclude null (below is just an example of how to exclude nulls):

     

    Hi Yeok, Bring your two table calculations in the filters shelf and exclude null (below is just an example of how to exclude nulls): Thanks, Mavis

    Thanks,

     

    Mavis