Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Community,
i have a tablebox with five columns and a lot of rows. The user has now the possibility to filter the data by selecting one of the values in any column or row. I want, that this filterfunktion is disabled for all other columns than one. Perfect would be if the user could klick at any point in a row and only the filter of one field in this row is set.
Example : Date | Partnumber | Supplier
02.2014 0815 EXP
User can klick at the date- or Partnumber field but the filter for the supplier is set.
Thanks for your support!
Hi,
Create alternate state in document properties and place it in table box.
and if want to filter the table box as per the slection in supplier then same alternate state can be place in suppliers filter box.
Hi,
It is not possible in Table Box, instead you can try this in Straight table like below
Dimension: Date, Partnumber, Supplier
Expression: =Only({<Supplier=>} Date) - Assume Expression Name: Temp
Now go to Presentation tab and select Temp in Columns list and select Hide Column option.
Hope this helps you.
Regards,
Jagan.
Correct possible only in Chart type -> Straight table.
Also In Expression you can use the following:
Only (Date)
Only (Partnumber)
Only (Supplier)
Hide the dimensions: Date, Partnumber, Supplier.