Hi,
I have a combi chart which contains 2 series per department cash usage rate and one overall company cash usage rate. For the overall company usage rate, I just used an empty data item. The combi chart is affected by the filter applied. However, I want to overall company to be fixed and not be affected by the filter. So only the per department should be filtered. But what happens is that the cash usage rate (calculation of data items: cash/grossamount) for both is being affected.
Do you have any suggestion on how to solve this? Thank you.
is cash usage rate a separate calculation/data item? and you used this both to department and overall????
if so, dont use the "cash usage rate" data item for the calculation of overall, write the calculation as is.