Forum

Notifications
Clear all

Calculated Item error

4 Posts
2 Users
0 Reactions
76 Views
(@einars)
Posts: 2
New Member
Topic starter
 

Hi,

Please help me.

I want to count two columns in Pivot Table Pivot-1-1.png, but I am not allowed to perform a function - Calculated Item.

There is errorPivot-2-1.png. Where is the problem?

 
Posted : 02/03/2021 5:52 am
(@debaser)
Posts: 836
Member Moderator
 

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
(@einars)
Posts: 2
New Member
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
(@debaser)
Posts: 836
Member Moderator
 

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
Share: