Hello,
I have a pivot table where I've manged to get a running total for a give 'item' and stopped the returned value being duplicated,
I thought the best way to do this would be keepfilters but could not get it to work, so wrote one measure
Whch gave a running totaal by each item, then put this measure in ;
the finished measure called NewT in attached workbook.
This does give the result I was after but not sure if it's a very good way of doing it, if anyone have any better ideas please let me know
work book attached showing all attempts.
Richard.
Bookmarks