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:







      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.