5 Replies Latest reply: Sep 12, 2016 5:30 AM by Jonathan Dienst RSS

    Set Analysis in calculated variable

    Robert Waterval

      Hi Guy,

      I have a variable wich is set and calculated as Include statement in the script

       

      vProject# = sum({$<[ForecastCategoryName] = {'Pipeline'},DateType = {'Snapshot Date'}>}[# Opportunity])

       

      And the front end expression of the chart is defined as $(vProject#)

      But now i have several dimensions like country and year which a want to slice and dice trough this calculation in the frond end

       

      How do i write this properly?

      sum({$<[Year] = {'2016'},($(vProject#)) will not work. Pls advice

       

      Thanks!

      Robbie