Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Guys,
I encountered with a scenario where
IF the vendor number is different against the same vendor name than that is a duplicate vendor not when it displays against the same vendor number ;And if vendor name repeats one time with different vendor number than in pie chart it will display under the category 1 and if it repeats more one time than it will displayed as >1 Duplicate Vendor.
So, Final output for the given scenario have to be
Against 1 Duplicate record : 1
Against >1 Duplicate Record : 2
I am attaching the Excel here for this scenario and QVD .
Thanks is advance , any help is appreciated.
I think in your current scenario, all three Vendors are associated with multiple Vendor Numbers
But may be try like this
Dimension
=Aggr(If(Count(DISTINCT [Vendor Number]) = 1,1,0),[Vendor Name])
Expression
Count(DISTINCT [Vendor Name])