How to create customer class ?

[Anonymous]

Hi All

I need to create a report base on customer_classs base on below :-

sales from < 5K

sales from < 5K till >50k

sales from > 50 K

Can some one share with me link for kick start.

[Ashish_Mathur]

Hi,

Share the download link of your PBI file.

[Anonymous]

Hi Ashish

Thank you for your hep :-

https://www.dropbox.com/s/qycqi3tl6b9et19/PBT_V01015%20sales%20by%20class%20for%20key%20account.pbix...

Paul

[Ashish_Mathur]

That screen shows an error.

[Anonymous]

Hi Ash

https://www.dropbox.com/s/819o3cs3ssa5vo1/PBT_V01015%20sales%20by%20class%20for%20key%20account%20FI...

Pls try again

Paul

[Ashish_Mathur]

Hi,

You may download my PBI file from here.  See the second table.

Hope this helps.

[Anonymous]

Hi Ash

Thank you very much for your help , it work , but now i need to count number of customer by class.

[Ashish_Mathur · Accepted solution]

Hi.

You are welcome.  You may download my PBI file from here.

Hope this helps.

[Anonymous]

Hi Ask

Now when i load the actual data , i notice that i need to move the centre column to right side. Can you advise me how to move ?

[Ashish_Mathur]

Hi,

Refer to the image

[Anonymous]

Hi Ash

thank you for sharing 

Now my issue I need the Bracket arrange in following sequences :- 

<=5000

5000 - 300000

>=3000000

But now the report display as :-

<=5000

>=3000000

5000-300000

Hope you can advise me how to make it sort as above 

Paul

[Ashish_Mathur]

I already have shared the solution with you in the previous screenshot.

[Anonymous]

Hi Ash

yes it work fine now. After i change to :-

(1) <50,000

(2) 50,000-300,000

(3) > 300,000

Now it can sort from high to low

Paul