5 Replies Latest reply on Jan 19, 2019 10:26 PM by Mahfooj Khan

    How to count products number using lod

    kookhee kim

      Hello

       

      I tried to make bar chart counting products number by make section for discount rate.

      Below is the bar chart that I want to make.

       

      For example, I want to make section by discount rate.

      1. I made calculation field to make discount rate.

       

      1 - sum([net sales amount]) / sum([retail price])

       

      2. I used IF calculation field to make section for discount rate.

       

      3.  I tried to use LOD calculation to count products by discount rate section.

      Ship to Field means products.

      But as you can see below, DC% section makes problem because it is aggregated expression...

       

      How can I make right calculation field to count products by discount rate section???