Hello, I want to create a table with some KPIs. One of them calculates the number of different suppliers over a period.
Transaction list: Invoice (properties: Nb of Invoice (text), Supplier (dim), Month (dim), Cost center (dim) and Value)
Dimensions: Supplier, Month, Cost center
I used this formula:
Invoice.Supplier [BY COUNTUNIQUE: Invoice.supplier, Invoice.Month, Invoice.'Cost center']
It works well if I filter my view by month. But as soon as I select my entier year, it adds everything up (1,002) instead of counting the unique suppliers over the year (100). It's not the MAX function either, which would give me 98 as result.
I expect this result:
Jan 25 85
Feb 25 70
Mar 25 86
Apr 25 78
May 25 77
Jun 25 79
Jul 25 79
Aug 25 98
Sep 25 85
Oct 25 78
Nov 25 98
Dec 25 89
FY 25 100
Thanks for your help
