This content has been marked as final. Show 4 replies
Could anybody help me with one problem?
I neet to build a pivot table where one of expressions is sum of sales. But I would like to sum up sales in only those units which reported any sales in the corresponding period of the last year. Simply, I would like to sum up sales of stores that worked/existed last year. Should I use set analysis (how) or some fancy 'if' formula?
Thanks in advance,