Notifications
Clear all
Topic starter
Hi,
Please help me.
I want to count two columns in Pivot Table , but I am not allowed to perform a function - Calculated Item.
There is error. Where is the problem?
Posted : 02/03/2021 5:52 am
It looks like you are using FSA Status for the count and also as a column header. As per the message you are getting, you cannot use any field in the data area and another area if you have a calculated item. Is there another field you can use for the count?
Posted : 02/03/2021 8:31 am
Topic starter
I tried to use another field, but doesn't help. Is there another way to count two columns in Pivot Table?
Posted : 02/03/2021 12:47 pm
You could just group the items? Or create an additional column in the source data that returns the same name for both items you want grouped.
Posted : 02/03/2021 12:55 pm