Hi,
Here is a question, in salesforce.com there are 2 project ID. They are independent projects but they have, in our eyes, same ID
ID number 1: 1234567890A
ID number 2: 1234567890a
the only difference is on the last letter "A" vs. "a". When I perform a pivot on this datatable they would be counted as one showing
Project ID Count
1234567890A 2
Is there a way to have pivot table to show them on 2 separate lines??
Here is a question, in salesforce.com there are 2 project ID. They are independent projects but they have, in our eyes, same ID
ID number 1: 1234567890A
ID number 2: 1234567890a
the only difference is on the last letter "A" vs. "a". When I perform a pivot on this datatable they would be counted as one showing
Project ID Count
1234567890A 2
Is there a way to have pivot table to show them on 2 separate lines??