Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Goal - I have straight table in which I want that each columns shoes count of selected date , selection is made from listbox I of dates
Suppose If I select 4 dates from list box then in case I get 3 columns which should show count of products on that particular date.
It's client data so cannot share QVW
Thanks for help in advance
Need help urgently
Your question is not related to the Alternate states. But title looks like "Alternate States".
Anyway, Can you explain sample data set? Because, we never ask to share your client data with public.
take a pivot Table.
Dimension is your Product
second Dimension is your Date field
Expression: count( product)
then press finish and drag the date field to the right upper corner of the table, so the blue line is horizontal.
hope that helps 😉