Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
prime_streamer0
Contributor II
Contributor II

How do I hide a primary key column before downloading a table to excel

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.

Labels (2)
0 Replies