Hi,
I have a report where I am using a bar chart. In the Y-axis we have the various products and in the Series we have the revenue actual and revenue target.
I want to conditionally format the revenue actual data , i.e different colour of the actual bars based on different conditions.
I have created a conditional variable with the values and in the conditional pallete when I am assigning the string variable, both the fields revenue actual and target is actually getting conditionally formatted. However I want only the actual field to get formatted .
Also I need a bar which shows the total actual and targetted revenue. Is this possible?
Need help.
Thanks.