Hi Mynda Thanks for your reply. I added another filter criteria into the first formula listed above, however all it did was make Opening Custome...
Hi Mynda Sorry, it is a mistake in the file. Also Zac's date was incorrect should be 2018 and not 2019. I have updated the file. Thanks ...
Hi Catalin It works! Thanks so much for helping me out on this. Kind regards Jon
Hi Catalin The way I worked out the combined categories was to use the IF formula to work out if it is a New Business or Recovered. If it returned ...
Hi Catalin That is where I have been struggling in working out how I can split between churn-upsell and churn-downgrade in separate headings. Fo...
Hi Catalin Thank you for your reply. Correct, it was my error in relation to Customer 8. Customer 11 and 12 is a combination of churn and up...
Hi Mynda I have attached a mock up file. The data is very basic just has the customer name and the subscription amount per month for each custo...
Thanks so much for your help. So I either show all P&L accounts and not be able to use both Slicers or use SUM and don't show the full list.
Hi Mynda Thanks for replying to my question. The reason for the measure is so that in the Rows section of the pivot table I can show all items e...
Hi Mynda I will have a read of the article and try to work it out. As always thanks for your help and I do appreciate it. Thanks Jon