Dynamic display

3 posts / 0 new
Last post
FrankE
Dynamic display

How to hide the colums (fylke)  where sum=0 ?

 

 

Frode
Frode's picture
Remove empty fylke (states)

Hi Frank!

This is a datatable where you use PIVOT I suppose?

Have you tried to add a column filter where you set filter to be larger than 0 on the value column ?

Example:

You can do it from the editor. Right click the (city column) in my example and select "Edit column":

 

Then all rows with value > 0 will be removed.

 

 

FrankE
Dynamic display

No, this is not a PIVOT,

Log in or register to post comments