Hello all need your help. In the attached image I want use date filter to show in that filter term [amount]、[rank] and [bookmarked_date] count in one pivot table and when term change then the [amount]and[rank] summary also change.(Now the bookmarked_date] set in value item so can change by filter)
But now when change the date filter term the [amount] and [rank] cannot change because these set in row item. If set in value place cannot show the table like image shows one.
And not want fixed the date.
How can I create this pivot table or pivot table cannot do like that? Thanks!
[amount] shows in the filter term sum of each day’s count
[rank] shows the ranking about [amount]
[bookmarked_date] shows each day’s summary.