Hi All
We have just moved on to DAX from Oracle and I am trying to get my head round the JET reporting tool, not sure if that is covered here ?
I have a report that returns all our Invoices/credit notes in a month split by customer.
I can use the hide+ in col B to hide any lines that are 0 by use of a =if() which is working
We want to hide any customer Names/details ie (header row) I tried to also hide this via the =IF() referencing the Invoice and credit lines below, this doesn't work.
Question is should it work or can you only use the hide/show formula against the lines below your header ?
Next Question is there a way of hiding the header rows, when the query lines below return 0 ?
Thanks Dan
We have just moved on to DAX from Oracle and I am trying to get my head round the JET reporting tool, not sure if that is covered here ?
I have a report that returns all our Invoices/credit notes in a month split by customer.
I can use the hide+ in col B to hide any lines that are 0 by use of a =if() which is working
We want to hide any customer Names/details ie (header row) I tried to also hide this via the =IF() referencing the Invoice and credit lines below, this doesn't work.
Question is should it work or can you only use the hide/show formula against the lines below your header ?
Next Question is there a way of hiding the header rows, when the query lines below return 0 ?
Thanks Dan
