Hello.

I have Dropdown field named (Procedure) with options:

"Primary implantation 1xICD"

"Primary implantation 2xICD"

"Primary implantation 3xICD"

"Replacement of implantation 1xICD"

"Replacement of implantation 2xICD"

"Replacement of implantation 3xICD"

"Explantation 1xICD"

"Explantation 2xICD"

"Explantation 3xICD"

And i want to create pie pivot chart with two options of data:

1. Primary implantation that contains summary of "Primary implantation 1xICD", "Primary implantation 2xICD", "Primary implantation 3xICD"

2. Secondary implantations that contains summary of "Replacement of implantation 1xICD", "Replacement of implantation 2xICD","Replacement of implantation 3xICD","Explantation 1xICD","Explantation 2xICD","Explantation 3xICD"

But i have trouble , how to use Aggregate formula with my question or another solutions

Thanks !!