Keeping Excel formulas when refreshing Quick view with new PoV

Krjac
New Contributor

When refreshing a quick view after having changed the PoV, any formula in the row that is refreshed will be cleared.
Is it possible to retain the formula ?

Example:

A1 Formula B1 PoV C1 PoV

When changing B1 and C1, and refreshing A1 will be cleared.

Thanks!

1 ACCEPTED SOLUTION

db_pdx
Contributor III

In the Quick View settings, at the top are two settings: "Insert or Delete Rows (Columns) When Resizing Cube View content".  Try turning both to False and see if that fixes your issue.

View solution in original post

2 REPLIES 2

db_pdx
Contributor III

In the Quick View settings, at the top are two settings: "Insert or Delete Rows (Columns) When Resizing Cube View content".  Try turning both to False and see if that fixes your issue.

Krjac
New Contributor

Thanks this seems to work!