3 Replies Latest reply on Aug 6, 2018 11:07 PM by Ryan Julius Banez

    Category associated with LOD function

    Ryan Julius Banez

      Good day


      I used the APAC superstore as test data for my inquiry. Suppose I want to know which Country originated the Maximum total sales per order last August 2015 (Answer is China).


      I did LOD for Sum of Sales per Order ID: {FIXED [Order ID]: SUM([Sales])} and I can use the Month-Year filter to show only August 2015. Nothing difficult there except that it shows the number.


      I want this to show China.png


      However I want it to show China instead of 6,607. Something similar to a VLookup.


      I searched the forums and the closest I encountered is this tutorial --> Calculated Field (LOD) as Lookup Criteria


      However, when I apply the same thing on my worksheet, it breaks down everything per country. I only want to show the country where the maximum sum of sale per order was computed


      This is what I get following the tutorial.png


      I would appreciate any help.


      Thank you.