Nov 17 2021 10:15 AM
Hi, I am using the GETPIVOTDATA function to get information in a table.
I change the arguments with specific cells $A$3 instead of the name of the argument.
In line 17, I want to have the result of every reception in december, year 2020, for the 4 criterias you can see in purple.
Here is my function (it is in french) :
=SIERREUR(LIREDONNEESTABCROISDYNAMIQUE("Somme de QtyReception";'TCD Réceptions'!$A$1;"AnneeFinanciere";$B$11;"MoisFinancier";B$13;"Univers";$C$1;"Division";$C$2;"Classe";$C$4;"Capsule";$C$3);0)
For the moment it works well, but I would like to use an asterix * instead of ROBE/DRESS to see the data for only 3 criterias, instead of 4, but I get an error code.
I already used the asterix in OLAP PIVOT TABLE and it worked perfectly.
Is there an equivalent option I can use instead of the * ?
Thank you!!