Forum Discussion
Cumulative total on two tables
Hi camargos88 ,
Based on the data and formula you currently provide, it can return the correct value. Could you please provide some screen shots about the below scenario? We need this information to see if we missed anything...
As soon as I place column from Dim table (i.e Name) the running total stops working and it displays the actual totals instead.Best Regards
Rena
Hi camargos88 ,
Based on the data and formula you currently provide, it can return the correct value. Could you please provide some screen shots about the below scenario? We need this information to see if we missed anything...
As soon as I place column from Dim table (i.e Name) the running total stops working and it displays the actual totals instead.
Best Regards
Rena
Hi Anonymous and camargos88
Thanks for you inputs. Actually upon investigation found that the join between fact and dim is many to many which is causing the issue. There are some duplicates in dim table which we removed from backend table and the formula that I posted worked without any issues. Thanks again it was backend table issue at the end.