Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Sunny
One more issue am having which is how to present the cumulative total as at July in Total row. Once Aggr function is applied, it calculate the total of running total
Thanks
Neville
Dear Members,
Could any one help me on this?
Thanks
Neville
Pretty sure you need the following to help you get it sorted out:
The only other option would be to use RowNo() or RecNo() functions in the load to force every row in the pivot table to be unique at that point, which should then make your totals equal as well... Hopefully I am on the right track here.
Regards,
Brett