Forum Discussion

Keith321's avatar
Keith321
Copper Contributor
May 12, 2022
Solved

Help with adding data pulled in with Pivot Table. Is there a way to sum dynamic multiple cells?

Hi, I have workbook that with a pivot tablet that pulls in data from a sql server. I am trying to sum items pull in by a specific lot type, singles vs towns. I can't use countif, (at least I don't think I can), because the the report is dynamic and so the type and counts don't always appear in the same cells when pulling the data.

 

  • Keith321 

    Perhaps you may use another PivotTable in which using DAX measures show filtered summary. If you are on Windows and use data model.

2 Replies

  • Keith321 

    Perhaps you may use another PivotTable in which using DAX measures show filtered summary. If you are on Windows and use data model.

    • Keith321's avatar
      Keith321
      Copper Contributor
      Thanks for the suggestion Sergei! I will give this a try.

      Take care,
      Keith

Resources