Need Answers for the below Questions

[Rudresh]

Hi Team

I need to Know

1) how to  Show the category and  subcategory of all those orders where sales is greater than $500

2) Show the first visit of each customer?

[aleksvp · Accepted solution]

For the first question, there are many ways to do it, depending on your data.

A very basic solution:

- Let's assume you have a measure, TotalSales;

- You can put category, subcategory and the measure in a table visual, than in the filter pane, select TotalSales, "is greater than" and put 500. 

For the second item, we need more info.

[Rudresh]

Hi Len,

Thank you for the information sure i will provide the data

[Len_Barr]

Its almost impossible to help you here as there is no data or visualisation supplied - you need to include photos either of mock up data or at least the row names and visualisations