2 Replies Latest reply on May 7, 2013 8:14 AM by stephen.farver

    Help with Reducing Multiple Lines for Calculated Fields

    stephen.farver

      Hi All,

       

      I am working to create a dashboard to examine product cost increases. While I am able to successfully design some of my views, I am having trouble calculating what the effects of inflation have been across various product lines. Using the Superstore template, I replicated my views and the problems I am encountering (please see attached). In order to calculate certain fields over a dynamic period of time, I must include the Year, Month, and Day for them to aggregate the correct amounts. Is there anyway to replicate the same results via one line? Perhaps blending the calculated data into the actual data and then pulling that?

       

      Please let me know if this makes sense -- I appreciate any suggestions 

       

      Regards,

      Steve