Hi,
I made two lines. The blue line is based on selected product. The orange line is for all product(should not be changed by the filter Product). I used FIXED to write calculation for this situation. Just curious is this the best way to realize this requirement?(Not very confident to use FIXED. Worried when more conditions added later, FIXED function will be adjusted). Any simpler way?
The workbook is attached. Thanks for your help!
Yun
2 answers
Hi Yun Jing,
As per my understanding you need to use LOD FIXED OR INCLUDE Without LOD It will not possible So your way is good for that.
