3 Replies Latest reply on Jul 23, 2018 7:18 AM by meenu choudhary

    Create calculated field on top a Dimension table's column

    Ayan Chakraborty

      Hi Friends,

       

      I am trying to make a calculated field on top of a dimension table to get the number of rows from that particular table.

      Let me describe it a bit more.

       

      1. I have a user table which have 80 users in that table.

      2. In the fact table I have 100000 records, but, in between this 80 users there are only 30 user id is present in the fact.

       

      Now I am trying to built a count of total user(eventually column is from the user table), but it is returning 30. I am really surprised. Please guide me.

       

      **Note** The column name in both the table is different.