4 Replies Latest reply on Jul 14, 2014 11:29 AM by Shawn Wallwork

    Displaying an aggregated value along with non aggregated dimensions

    Philip George

      Hi,

       

      I have attached one sample workbook for the reference.

       

      In the first tab  I need to display Week-ship date,product container and minimum of order date. Minimum of order date should be irrespective of the Week-ship date.In the attached dashboard if you see the product container "jumbo drum" which is having a Min.Order Date="1/2/2010".But this value varies in each ship date week for that product container.Here I need to display min.Order Date as "1/2/2010" in all the rows for the Product container "Jumbo drum".

       

      Which are the different options to get this type of report?

      Can we achieve this without using datablending?

       

      Regards,

      Philip