2 Replies Latest reply on Jun 28, 2016 5:16 AM by khadeer.shaik.0

    How to add Total Column(Based on condition) to a cross tab?

    khadeer.shaik.0

      Hi All,

       

       

      I need to add a total column in my cross tab:

      I am using date field, when i trying to add a column it is slicing based on Date Column, so unable to add Total column?

      Scen: If my quarter is >= Current Quarter then Sum(Sales)....i have to show total sales for current and future Quarters in place of Grand total:

      i have calculation to calculate Total for Current and Future Quarters, but when i added it is slicing by quarter:"

      Help me to resolve

       

       

       

      Thanks

      Shaikk