SAS VA report : specific distinct count - is it possible?

[Filipvdr]

Hi All,

I got the following problem:

Data looks like:

Article	Shop	Supplier	Value
A	1	SUP1	1
A	2	SUP1	1
A	2	SUP1	1
B	2	SUP2	1
B	2	SUP2	1
B	3	SUP2	1
B	3	SUP2	1
C	3	SUP3	1
C	3	SUP3	1
C	3	SUP3	1
C	4	SUP3	1
C	4	SUP3	1
C	4	SUP3	1

I want to report to count the values for each Supplier, but only select for the distinct (Article, Shop) combinations.

Is this possible in VA?

[Filipvdr]

ok, stupid question, i just have to use a distinct article...

[MichelleHomes]

You can create a new data item as a Distinct Count on your Article data item as described in the SAS(R) Visual Analytics 7.1: User's Guide - Working with Data Items

Let us know if this helps. If not, please provide a report/table of what you expect as your end result.

Kind Regards,

Michelle