Subscribe now and choose from over 30 free gifts worth up to £49 - Plus get £25 to spend in our shop
Chat Forum
2
Posts
3
Users
0
Reactions
42
Views
Topic starter
Ideally I'd like to be able to click/hover on/over a row heading and a box to appear which shows the summary of data in that row.
I've been looking at grouping so I can collapse and expand to show a data breakdown that way but just wondering if able to do it as described above that gives only a high level summary of the data ie totals.
Thanks in advance.
Posted : 20/05/2019 9:29 am
Pivot table
Posted : 20/05/2019 9:34 am
You can add formulas i.e. totals to comments, but it requires VBA knowledge so isn't that easy.
Can you not just have the summary calculations in cells at the top of the data?
Posted : 21/05/2019 12:56 pm