Hello Experts -
I am creating a table mostly based on formulas to lookup raw data to arrive at some results. This table is much customized which I could not arrive out of a pivot table
For example:
I have multiple levels and sublevels to show them orderly for which I need to create multiple pivots and place them at right position.
Is it possible to have my table just based on formulas but when clicked on a data within the table show me the actual data behind it. the same effect that pivot table does?
I am creating a table mostly based on formulas to lookup raw data to arrive at some results. This table is much customized which I could not arrive out of a pivot table
For example:
I have multiple levels and sublevels to show them orderly for which I need to create multiple pivots and place them at right position.
Is it possible to have my table just based on formulas but when clicked on a data within the table show me the actual data behind it. the same effect that pivot table does?