Hi, I've a cross-tab view to display, in which 2 columns has to be time-based (coming from fact table like that), but one of the columns should not be time-based (only latest COUNT). All of the columns are time-based, but for total cells I just want to show latest result (top 1).
Attached is a picture of how it looks, and what I want to achieve is to show only the total cells for the latest time (with a CollectionTime filter of latest snapshot).
Can this be done? If not, can I have 2 different cross-tabs and display them in the same Dashboard to achieve desired output?