Hi all,
I have a straight table with single primary key on it (FACT_ID) and more than 100 Dimensions in it. This primary key field has a condition =If(FlagInitial =1 and FlagSecondary =1, [FACT_ID])
which helps to restrict the no of rows on the table.
The requirement is that we should not show the FACT_ID on the straight table.
If I conditionally remove the FACT_ID, I am getting more rows since the flags were not applied.
Please suggest a solution.
Thanks in advance.