Straight Table

[_rohitgharat]

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

[Anil_Babu_Samineni]

I don't think so whether it is possible, Can we know why we need this? Always i learn from marcowedel‌

[mangalsk]

It is not possible but you can give 1 button as details on click of this redirect to sheet having detailed information

[Kushal_Chawda]

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)

[techvarun]

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 

[Anil_Babu_Samineni]

But, his intention to hit over expression not in Dimension, May be?

[Anil_Babu_Samineni]

This is not good idea as i assume, What if you have around 1L rows in straight object ??

[neha_shirsath]

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

[qv_testing]

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....

[effinty2112]

Hi rohit,

Have you considered a table with a calculation condition of

Count(DISTINCT City) =1

?