Scribd
Upload
2 views3 pages

ANSWER Module 2.2

Filters in a customer graph allow users to display specific data, such as showing only Mumbai customers by selecting them from a dropdown in the City column. After filtering, a column chart can be created to visualize sales data for the selected customers. Additionally, pivot tables can be utilized for customer clustering analysis.

Uploaded by

Prasad Chauke
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
2 views3 pages

ANSWER Module 2.2

Filters in a customer graph allow users to display specific data, such as showing only Mumbai customers by selecting them from a dropdown in the City column. After filtering, a column chart can be created to visualize sales data for the selected customers. Additionally, pivot tables can be utilized for customer clustering analysis.

Uploaded by

Prasad Chauke
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

1.

what is use of filter in customer graph


ANS:
When we apply filter small dropdown arrows appear in column headers.

Now I’m going ,


1. Click the dropdown in City column.
2. Uncheck all.
3. Select only Mumbai.
4. Click OK.
Now only Mumbai customers will appear
1. Select Customer and Sales columns.
2. Go to Insert → Column Chart.

Now the graph will show sales only for Mumbai customers.
2. Use of pivot table in customer clustering

You might also like