How can I use the total row counts of workbooks in a pie chart?


1 comment

  • Official comment
    Joel Stewart

    This could be accomplished using the following steps:
    1. In each of your Worksheets, add a column that identifies the worksheet name (i.e. SheetName = "WorksheetA")
    2. For each of your Worksheets, create a Grouping Sheet that has exactly two functions: GROUPBY(#WorksheetA!SheetName) and GROUPCOUNT()
    3. Union the Grouping Sheets together so that you end up with a Sheet that has 3 rows, one for each Worksheet.

    Ensure that the Unioned Sheet is a saved sheet then build a Pie Chart widget from this result.

    Comment actions Permalink

Please sign in to leave a comment.