That totally worked! Thank you for your help.. now if only I knew why we built what we did as well as what contexting the various filters did to assist in achieving that result?
Thanks so much once again,
1 of 1 people found this helpful
Since the calculation uses Fixed and this calculation will pre-calculate before any filter applied to view, so we need add filter to context.
Hi Zhouyi Zhang,
I just noticed that one of my columns (Master Open POs) within the Table Name have disappeared when I drill down from my dashboard.Would you be able to find a way to maintain both columns within the Table Name item in the BVA PO Tab? I'll be needing the Actuals as well as the MasterOpenPO's column .
Thanks for looking into this!