1 of 1 people found this helpful
1. Only CSV allowed. What are other simplistic ways to look at data for beginner?
Yes, data can be exported only in csv. Click on icon left to search icon to View Data. You can also select all data here and paste to excel.
2. The pound symbol wont let me do any pivots or calculations on sales numbers, Is there any formatting i can do to solve this?
This problem is only with EU superstore not with Sample Superstore. In excel Press Ctrl+A---->Ctrl+H------>Find what = £ ----->Replace with ---->Leave as it is. Click Replace all.
Worked fine! Thanks for your response Ombir!