Thank you very much for the Response , I have added the Recid field , but could not get scoping aggr function to work , can you please take a look. When I select a dimension row color does not change.
Hmmm...I see the problem. All the RecId values for a date get selected when selecting a Dimension. It does work for the expression columns. You could consider try converting all your Dimensions (except RecId) to Expressions.
By moving all dimensions to expressions , its not behaving the same... the colors problem gets fixed but it only selects the row which I clicked rather than showing all the values
Let me ask for a clarification. You want to click on the Date in a cell, for example, 2/28/2016. You want the date to be used as a filter, and therefore show only the the 2/28/2016 rows. But you want only the row clicked to be highlighted?
Another requirement - I want to select the Min value of Function when the document is opened , Why does not
min ( {1} function ) work ? I can have it to the triggers when the document is opened , and automatically min value is selected from API and so its colored, basically I am trying to color the first sorted value of Function when the document is opened
