Forum Discussion

Rudresh's avatar
Rudresh
Regular Visitor
3 years ago
Solved

Need Answers for the below Questions

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?

 

Tips and Tricks
  • aleksvp's avatar
    aleksvp
    3 years ago

    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.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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

  • Rudresh's avatar
    Rudresh
    Regular Visitor
    3 years ago

    Hi Len,

    Thank you for the information sure i will provide the data

  • aleksvp's avatar
    aleksvp
    Helper II
    3 years ago

    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.