Count Null values in pivot

[Anonymous]

Hi,

How can i count the null values for max month from this pivot table?

expression: Sum({<Kontonr={4297,4298,4299}>}[Bokført beløp])

[prieper]

Think that you need to construct a cartesian product betw accounts and month. Then you should be able to count all non-occurences within selected monthes.

Peter

[Anonymous]

Hi, Thanks for reply

Got an example for that?

[prieper]

just as aircode:

RunningCalendar: LOAD MONTH(Date) AS Maned INLINE (Date

1/1/2017

1/2/2017

1/3/2017

1/4/2017

......];

JOIN LOAD (RunningCalendar) DISTINCT Account FROM ....;

With this you should have a big table with an entry for each Month and existing Account.

Peter

[Sergey_Shuklin]

Hello, Marius!

You can check this topic:

checking null in set analysis

You can use expressions from there and modify them with maxdate condition, and you should get what you are lookin for.