Planning Ad Hoc Analysis: when we remove a member from the analysis to affect data at parent level

Summary:

Content (please ensure you mask any confidential information):

Hi all

We have a request from one of our clients that when they analyse data via Planning Ad Hoc, they want to remove a member from the analysis, by selecting Remove only, but they want that this removal to affect the data displayed at the parent level.

This is not possible, because this is not a flat spreadsheet, but a cube and removing it from the analysis does not remove it from the cube, but is there a way to ensure that this Ad Hoc is not connected to the cube somehow and works as a spreadsheet so when a row is eliminated, the total also changes?