Forum Discussion
Impossible to create Calculated Item in pivot table
Hi, I'm desperately trying to add a Calculated Item to a pivot table I have created in an Excel [365 for Mac] file. When I click in Fields, Items, & Sets > Calculated Item... but I get a cryptic ...
I don't know anything about DAX, but there are others here who do.
But perhaps it'd be easier to compute Echec/Réussite in the source data, so that you don't have to use calculated items. See the attached workbook.
I'm missed, do we speak about cached PivotTable or about data model PivotTable and is the latest available on Mac?
If data model we may add calculated column to the table as
=VAR niv=Table1[Niv_Global]
RETURN IF( niv IN {"A1 non atteint","A1","A1+"} ,
"Echec",
"Réussite" )(actually the same as add it was added to data source), name it it Niv_Global and use in PivotTable
Yes, thank you indeed @Sergei Baklan, and thanks again HansVogelaar for hitting up the right person!
Thanks, Sergei!
