Detach a column in a table

[yashcena]

Hi,

I have a datasheet which has 5 dimensions and one of the column is Project_Stage.

There is a filter for Project_Stage in some other tab of the application (not in the one having the my datasheet). There is default a project_stage which has to be selected when the document opens (i have a trigger for that).

However, I don't want the Project_Stage column in my datasheet to be filtered. Basically I dont want the Project_Stage column filter to be applied on my datasheet.

I can detach my datasheet but then all other filters wont get applied on it which i don't want. I only want Project_Stage filter to be not applied on the datasheet. I tried adding this calculated dimension but it did not work:

=aggr({<Project_Stage ={}>})

I think I'm missing something here and I cant figure out what.

I hope I have made the requirement clear. Any help is appreciated!

thansk,

YASH

[tresesco]

You can use set analysis with all the aggregation functions you have used in that sheet, like:

Sum({<Project_Stage>}Sales)

Count({<Project_Stage>}Customer)

[Chanty4u]

like this: sum({ <Project_Stage=>} sales)