3 Replies Latest reply on Jan 28, 2013 11:47 AM by Alex Kerin

    Can I combine dimensions?

    John Haldeman

      I have 24 columns = 12 payments amounts & 12 payment descriptions.  In regards to the descriptions there are 3 types (cash, credit card, discount).  I am trying to make a viz that will shows: Total Amount Paid on the Y-axis and the corresponding description on the X-axis.  I have already made a calculated field that gives me the aggregated amount paid, however on the x axis it is showing the 12 payment descriptions and then the 3 types of payments = 36 columns..  I want only the 3 (cash, credit card, discount) columns on the X axis. 

       

      Is there any way I can aggregate the 12 descriptions (dimensions) and only have 3 columns (cash, credit card, discount)?

       

      Thanks!

       

      John