3 Replies Latest reply on Nov 15, 2016 12:40 AM by sudhakar reddy

    Data download as Crosstab showing color legend also

    ajay tomar

      Hi,

       

      I am have created a tabular view which displays sales at Department x Customer segment level. In order to highlight sales value by different colors, based on my rules, I have created a calculated field and dropped it on Color marks and I am able to get the desired output.

      But when I download the data as crosstab it shows the sales value under different color buckets. I want that my downloaded crosstab data should have simple values and are not segregatted based on the color rule applied. Is it achievable. Attached is the sample workbook along with the crosstab data downloaded.

       

      Thanks,

      Ajay