Community
Participate
Working Groups
I would like to highlight a row in a crosstab if Forecast value is below Budget value input year product data_type value 2007 p1 BUD 4 2007 p1 FC 2 Crosstab-layout data_type year | product <value> Highlight expression data['data_type']['FC'] less than data['data_type']['BUD'] Result row including product name is highlighted
I would like to extend this wish to Allow formating on Row and Level at the moment I see no possibility to eg. introduce a gap between years
The data expression can only be applied to binding NAME, rather than dimension level value, so that the expression like data['data_type']['FC'] less than data['data_type']['BUD'] would not be supported. However we may consider introduce the idea of Axis Qualifier into highlight/map to fulfill similar functionality.
+1 to enhance the conditional highlighting support to Axis Qualifier.
As per discussion defer the bug to future.
Suggest to defer the bug to future. The introduce of Axis Qualifier into highlight/map is complex, meanwhile this kind of highlight usage is not very popular.
Is there other way to do forecast vs. budget comparison? or actual vs. budget comparison? Can you create two metrics one for forecast and one for budget based on the data_type when creating the cube?