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?
|