0 Replies Latest reply: Oct 24, 2014 7:14 AM by laura howarth RSS

    Totals in pivot table

      Hi All,

       

      I have a pivot table chart which has 3 dimensions. (country. business, name)

       

      i want to only show data which is not equal to yes in 5 indiviudal field expressions.

       

      which creates the following correct chart:

      CountryBusienssNamefieldafieldbfieldcfieldd
      UKUKAANON/ANO
      UKUKABNO
      UKUKBABCNO<not declared>
      FRANCEFRANCEADEFNO
      GERMANYGERMANYAGHYNONONONO
      GERMANYGERMANYBGERWNO

       

      As this is a pivot table when it is collapsed i want it to count the total number of rows with data in for that country

      So the above table collapsed would look like

       

       

      CountryBusienssNamefieldafieldbfieldcfieldd
      UKUKAA2121
      FRANCEFRANCEADEF1
      GERMANYGERMANYAGHY1121

       

      I do not know how to get the table to look like the above collapsed as the data is not numeric and the total part on the expression in properties is greyed out.

       

      Any help would be appreciated.

       

      Thanks,

      Laura