3 Replies Latest reply: Nov 15, 2016 2:55 PM by John Witherspoon RSS

    Count on a Dimension in a Dimension table & Fact table

    Mohammad Adnan Ansari

      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.