Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
like this: sum({ <Project_Stage=>} sales)