Quote:
Originally Posted by fundmark19
ok guys I am back. I have downtime so started messing with pivot tables and ran into a new issue. In one of my pivot tables I have 4 columns that are Text and not numbers I would like manipulate.
I have learnt about Measure's and have one in place however when I try to add more it gives me an error. Can you have multiple measures in one pivot? This is measure I am using
=CONCATENATEX(Values(Table1[Referral Source]), Table1[Referral Source], ", ")
Then I thought I could just mirror the data set and hide columns I don't need for this sheet. When I go to mirror I can't locate the file since it isn't locally stored and on our onedrive.
Any thoughts?
|
My thought is that isn't really a measure, but more like a calculated column. You can have multiple measures in powerpivot for sure, but measures need expression elements in them.
Not sure if this helps..
You could reference your new calculated column with a measure. If you're using regular pivot tables (not powerpivot), you're screwed