08-21-2023 07:00 AM
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.
08-21-2023 07:06 AM
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?
08-22-2023 12:08 AM
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.