I have a pivot table connected to a SSAS Cube. The Field List shows all the columns from the table. When double clicking a cell the detail sheet is not showing all the columns in the table. Is there configuration to show all the columns in the detail table. Is this by design show only few columns? What is blocking the columns to show up? How can I show the columns in the detail sheet. See my screen shots below:
ScreenShot 1: https://drive.google.com/open?id=1DaTyk-pajYX7sv739QOIgZt9mlW-dtc2
ScreenShot 2: https://drive.google.com/open?id=1A8L7pSW-bsvkqRp7kVyGQNTwGH9TeAMP
Screenshot 2 is the details table, but it doesn't have the following columns (COST CENTER,CPT,INTEREST_TYPE,OWNER,SALE_DATE). The question is how do I bring this column to the details table whenever a user double clicks on the [Sum of AMT] cell in pivot table
ScreenShot 1: https://drive.google.com/open?id=1DaTyk-pajYX7sv739QOIgZt9mlW-dtc2
ScreenShot 2: https://drive.google.com/open?id=1A8L7pSW-bsvkqRp7kVyGQNTwGH9TeAMP
Screenshot 2 is the details table, but it doesn't have the following columns (COST CENTER,CPT,INTEREST_TYPE,OWNER,SALE_DATE). The question is how do I bring this column to the details table whenever a user double clicks on the [Sum of AMT] cell in pivot table
