Ungroup Calculated Item only

[danielpp]

Hi everyone

I have 3 calculated items on my pivot ("Receita Bruta" ; "Receita Líquida" and "Lucro Bruto")

Is it possible to ungroup calculated items only?

The other items (those from the data source) should still be a group (containing all the subitems used to calculate the calculated items)

Capturar.PNG

[JeteMc]

In searching the web I saw a recommendation that using Power Pivot is the best remedy for this issue. Seeing as you have the 2019 version of Excel you may want to try that.
If you would like more specific help, you may want to upload a much smaller sample so that you can manually illustrate what you how you want the output to look.
Let us know if you have any questions.

[danielpp]

I was taking a look for solutions and PowerPivot seems to be the one that works. Still don't know how to use it I guess it's the only way to do

Thanks anyway!