Dynamic Division in a row on Dahsboard

[hitendrasingh]

Hi, I'm looking for a solution on dynamic row division to be performed in top of dashboard in insight. The divided number should change according to filter selected. I have attached the file for reference. 

I want to add a row in the aggregated table where it must take the number from existing rows and divide it according to the requirement. 

Thank you.

[RADSr]

I think what you want is a presentation variable integrated into your formula column something like:

( col1 + col2 ) / ?PV_divisior    

Or are you looking for a prompt with a pre-defined set of divisors?   

[hitendrasingh]

Hi, I am looking for solution on row 6 ( calculated 1 ) result will be in column B6 is division of B4/B5 Or B4/B2 base on the user need.

Is there any way to add calculated row inside the current insight based on the user need.