Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm having some issues with converting a pivot table into a line chart. I'm trying to display the % change quarter over quarter for a variable (TOTAGLN), one line displayed for the variable COMMERCIAL_BANK = 0, and one for COMMERCIAL_BANK = 1.
I was able to get the correct data into a pivot table using this formula:
(SUM(TOTAGLN) -Above(SUM(TOTAGLN)))/Above(SUM(TOTAGLN))*100.
When I put this formula into the pivot table, and add COMMERCIAL_BANK as a column, it gives me the correct values.
But when I convert it into a line chart, it doesn't display 2 different lines for COMMERCIAL_BANK, even if I've defined it as the line variable.
And also, the values are complete off. Please let me know how to fix this so the line chart displays the correct values.
Thanks!
Hi, adding a second dimension to a line chart will only make it an alternative dimension. So in your case it can either display year or commercial bank. If you want multiple lines, you have to duplicate your expression and add a filter for each commercial bank through set analysis.