Data Tables with Drop Down

[artempotsuray]

Hello everyone,

I have a question about condensing my data table. Currently my table has what is shown in the image below. My question is, is there a way for me to condensing the Gage Number catagory to show only the most recent EVENT_DATE but to still have a drop down like in pivot tables so that when I need to look at the previous event dates I can do so on the same table and not have to create another table.

Any help is appreciated

[ogautier62]

Hi

here on this dummy data :

last ticket shown for each item

with i=0 :

with as dimension for ticket :

if(i=1,if(NoTicket = aggr( nodistinct max(NoTicket),Article),NoTicket),NoTicket)

so in your case, something like :

if(i=1,if(date_event = aggr( nodistinct max(date_event),Article),GageNo),GageNot)

you can use a button to chage i too

regards

[Gysbert_Wassenaar · Accepted solution]

Create two tables. The first shows only the latest date. Add Gage Number and GAGE_DESCR as dimensions and max(EVENT_DATE) as expression. The second table is the one you have now, but you add a calculation condition so it won't show any records unless you first select one Gage Number: =GetSelectedCount([Gage Number])=1

[artempotsuray]

I have something similar to this. Now it shows only the most recent event date but the next step for me is to try to make a drop down on each Gage number so that when it is selected it would show the previous event dates as well as the most recent one. Is this possible?

[artempotsuray]

This works but for aesthetic purposes on my sheet, is it possible to make this info as a drop down instead of creating a new table?

[Gysbert_Wassenaar]

No

[artempotsuray]

Ok thanks for your help