Show Only # Rows is Dropping Series
I have a stacked horizontal bar chart.
Y = Sales Rep
X = Total Sales 2017
Series = Approved or Rejected. (The series is based on a beastmode)
Sorting = Sum of Amount - Decending.
The data runs just fine, but when I try to use the Show Only # Rows function, It'll drop the second value created by the series and just give me the totals for series 1.