Saturday, March 6, 2021

Filter/ Parameter hide based on Paramter selectoion

Steps:

1. Create 2 Param1  and Param2. Param1 will be visible all the time the other will appear based on  selection on Param1.
2.Create blank sheet having avg(0) on rows and columns
3. Add Param1 in blank sheet and add values based on which the Param2 will be hide.
4. Add Paramters1 and add blank sheets and then add PArameter2 and add floating object on Parameter2

Please check below link.



This approach will work good in Fixed layout where as for Autoimatic layout there is a chance the floatig object will distorted.

at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

How do I find only strings that contain precisely "ABC" (upper case), but not those that contain "abc" or other upper/lower case combinations?

  How do I find only strings that contain precisely "ABC" (upper case), but not those that contain "abc" or other upper/...

  • Real Time Scenario
     1. Color of first and last bar same and other bar same 2. Divide the data into 2 sheets 3. Parameter Month/Quarter then in sheets Year-mont...
  • Filter/ Parameter hide based on Paramter selectoion
    Steps: 1. Create 2 Param1  and Param2. Param1 will be visible all the time the other will appear based on  selection on Param1. 2.Create bla...
  • Calculative field
    1. Some calculations comes under Diemensions and some under Measures 2. Some calculation we can change from Dimension to Measures and vice v...