Please See word file for desired out put.
I'm trying two create wo dimensions Pre Grp & Post Grp , but my calculations are not working . any help will be greatly Appreciated.
Hi Sunny ,
yes , pre null values goes to Pre Field & Post null in Post Field .Every month we get new record for ID . so you might have 3d fall there . but it always stores pre null values in pre Field & Post null in Post field. so cinase were we have 3D fall . when we select month Filter Our Post & pre values will change accordingly.
Hey sunny ,
I tried to debug it and looks like ISnull() function is causing issue . is there any alternative for that .. or any new logic I should be using.