Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a following requirement:
Suppose in the straight table having following attributes:
Zone | State | City | Headcount |
West | Maharashtra | Pune | 30 |
West | Maharashtra | Nashik | 20 |
If user clicks on headcount 30 a separate table should appear having all the information related to those 30 employees. and same for 20 also.
Can anyone help me with this??
Thanks in advance.
Regards,
Rohit
I don't think so whether it is possible, Can we know why we need this? Always i learn from marcowedel
It is not possible but you can give 1 button as details on click of this redirect to sheet having detailed information
Create another straight table
Dimension:
Zone ,State,City, EmployeeID
Expression:
Write Head Cout Expression
When you select any number from original table, it selects the associated dimension in that table, so in another table go to properties ->Layout-> In conditional put below expression
=if(getselectedcount(Zone)>0 and getselectedcount(State)>0 and getselectedcount(City)>0,1,0)
It is possible using
Fixed Straight table
Invisible(Transparent) Buttons
Toggling between filters and Charts using Variables etc
But definitely not a suggested design since redesign is almost not possible and managing the dashboard layout is very tough
But, his intention to hit over expression not in Dimension, May be?
This is not good idea as i assume, What if you have around 1L rows in straight object ??
Hi,
Might be this is not possible but you can do something like adhoc report where you can give user list of dimension to choose details for Headcount.
Thanks,
Neha
I don't think so possibility in Straight table.
you can achieve in Pivot table.
Dimensions: Zone, state, City (City drag to up)
Measure: Count(HeadCount)
If you select Nasik or Pune. that should work.
in your detail report write this condition in Layout tab
Conditionla Property: GetSelectedCount(City)) >=1,0,1
hope it helps....
Hi rohit,
Have you considered a table with a calculation condition of
Count(DISTINCT City) =1
?