Pie chart color scale
I have created a cross table inspotfire that display the latest record for each product along with the grand total- ( see attached- "latest record pie chart" report) .
I want to create a pie chart based on a cross table grand total.
What i m looking for is coloring the pie chart based on a scale segement of gand total value.
For example in my case if the grand total percentage is less than 50 "red color" . if the grand total= 50-70 "yellow ". if grand total = 70 - 80 "orange" , if grand total = 80-100 "green".
Is this possible?
Thank you for your help.
I think I know what you're trying to do. You're trying to access the last column (Grand Total) of your cross table as rows of data. Is that right? Then that would mean you could make the following: