16 Replies Latest reply: Aug 19, 2014 12:18 PM by Antonio Mancini RSS

    Limit # of Rows in Chart (Pivot Table)

      Hi everyone,

       

      I have a Pivot Table in which the dimensions are conditionally enabled. The user selects from a list of dimensions and then the chart 'builds' itself just like a traditional pivot table in Excel. Dimensions can carry a varying level of granularity so I would like to have a calculated condition on the chart so that the user doesn't create a pivot with say more than 100K rows of data returned.   Is there a way to set this calc condition so that the chart won't display if the combination of user selected dimensions and expressions would result in a chart with >100K rows?

       

      Thanks!