Forum Discussion
How to show certain information at a particular stage
Hello, I'm new to using Microsoft Excel so I don't really know what I'm describing or what to call it here. What I would to know how to do is, as it says in the subject line, display certai...
Hi Bryan,
For the first part, if you organise your data in Excel table you may filter your data by slicers or directly from table headers. Latest works for the range as well if you apply filter for the data.
Total could be calculated in Pivot Table, the only you shall define somehow which week number for which month/year. Could be done in one more column by formulas or you may add months manually. If only you won't use dates instead of week numbers (e.g. last date for each week).