In the value area section of a normal Pivot Table one can only show the result of aggregation functions such as SUM(), COUNT(), AVERAGE() etc. Even if one drags a text field to the value area section of a Pivot Table, one cannot show those text fields because they automatically get counted. Consider the following […]
Read More →
Show text entries in the value area section of a Pivot Table after meeting certain conditions
{ 0 Comments }