Now that our data is ready, lets create the Pivot Table. Your final data for the Pivot Table will look like this: How NOT to use Concatenate Function to build Dynamic Text in your Excel Dashboard Templates If you want to learn more about this, check out this post: If Month is in A1 and Region-Product is in E1, then my formula in E2 =C2&”-“&B2 (or if you need to use Concatenate, then it would =CONCATENATE(C2,”-“,B2). So create a new column of data next to Amount. In my case, I don’t use the Concatenate function, but instead I just use the & (Ampersand) between the cell references and other text.
We need to create a Concatenated column of text that combines the Region and the Product. Now for our Pivot Chart, we will need to add one additional column of data. If you found the website and tutorials helpful, please consider donating to keep the lights on.
