
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?
Message was edited by: Yeok Song Ng
답변 3개
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