0 Replies Latest reply on Mar 11, 2013 12:30 PM by Sebastian Ganame

    Applying different filters for columns in a crosstab-like report

    Sebastian Ganame

      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?

       

      Regards,