5 Replies Latest reply: Nov 4, 2016 2:07 PM by Robin Hausdörfer RSS

    Sorting in a Chart

    Seth Rosenbauer

      I'm having the following issue.

      • I have a pivot table
        • Dimension: Product and Date Sold.
        • Expressions:
          • 1.  Amount of total sales
          • 2. Percentage of total sales BY DATE

       

      .My problem is that the percentages are displayed over the entire date range instead of just one day. See the table below for an example of what I mean.

       

      EXAMPLE

      ProductDate SoldAmount% of Total by Date Sold
      BeerNov 1st620% instead of 28.5% SHOULD BE OVER JUST NOV 1ST
      Nov 2nd413% instead of 44% SHOULD BE OVER JUST NOV 2ND
      WineNov 1st826.6% instead of 38% SHOULD BE OVER JUST NOV 1ST
      Nov 2nd26.6 % instead of 22% SHOULD BE OVER JUST NOV 2ND
      LiquorNov 1st72.3% instead of 33% SHOULD BE OVER JUST NOV 1ST
      Nov 2nd 310% instead of 33% SHOULD BE OVER JUST NOV 2ND