hello,
here is sample data
https://docs.google.com/spreadsheets/d/155Sr_GxzghNS9LV6ThM6sT8igQ6o83qq/edit?usp=drivesdk&ouid=1132...
I have a slicer based on the metric of YYZ and integrated, yyz, and All are linked to YYZ via metric
Having three separate line graphs for each yyz, integrated, and All work perfectly...that is,whenever i change the metric via the slicer, all three graphs update perfectly
what i'm trying to do here is actually have Integrated and 'All' on the SAME line graph...so when I move the "Σ value" from the "All" table to the "secondary y-axis" (i even tried double stacking the "y-axis") of the "INTEGRATED" chart, the "all" line graph is just a straight line.
it looks like it's giving me the TOTAL of the metric spanning the time period , not the individual data points (e.g., let's say time period is from Jan to Mar and the revenue was $1,$2,,$3, respectively. the line graph for the "all" is showing $6 (1+2+3) straight line, not upwarding sloping as in $1, $2, $3)
