Count on a Dimension in a Dimension table & Fact table

[madnanansari]

I have these three tables in my app:

ITEMS

SALES

INVENTORY

I have to report the below:

- How many Items are defined in the Item master file.  (Count of items in item master file)

-How many items are available in stock (count of items in stock file)

-How many items have sales transactions (count of items in sales file).

pls. let me know how to do this analysis.

[Gysbert_Wassenaar]

I assume you've found out you need the count() function. But what are you having problems with exactly?

[shraddha_g]

What is d issue?

[johnw]

I assume all items are in the master file. I don't know your field names, but something along these lines perhaps.

count(distinct Item)
count({<StockAmount={">0"}>} distinct Item)
count({<SaleAmount={">0"}>} distinct Item)