Hi...
I have created a Dashboard to look at some Credit Analysis...
I have two lines of KPI's on the Dashboard (each with a text box to show each KPI) showing stats for the previous month (cad_HistoricalMonthNumber = 1)...
On the first line I have the Total issues then a site breakdown of same ...
Total Issues Glasgow Oxford...
20 15 5
On the second line, I have a breakdown of the reason codes...
Sales Yard Distribution....
10 5 3
I have a site filter which, when selected, I want to affect the second line only i.e. I do not want the first line of KPI's to be affected by the filters...
I have tried the following with no success for my Total Issues KPI but with no success...
NUM(COUNT({1}DISTINCT {$<cad_HistoricalMonthNumber = {1}> } %IssueKeyHeader), '#,##0;(##,##0)')
Am sure i am doing something basic wrong and would be grateful for any assistance...
Thanks
Paul
