3 Replies Latest reply on May 7, 2018 8:31 AM by Don Wise

    Need help in creating a calculated field

    Christopher  Siddharthar

      Hi,

       

      I need your help in creating a calculated field that will provide the Contribution%

       

      Let me explain using the superstore dataset. I want to know how much the product 'Xerox 1967'  is contributing to the total sales of 'Category: Office Supplies' (Assume we have the total sales figures of all the product categories). I tried using the window_sum () function but unable to get the expected result. Your help will be greatly appreciated.

       

      Thanks,

      Chris.