Yes. Very achievable.
It is called histogram. The order categories are bins. CountD(Order Number) is the count.
can you supply a sample workbook?
You can achieve final you by creating calculated filed and place in row shlef
if [Amount $]=<10 then "0-10$"
ELSEIF [Amount $]>11 and [Amount $]<20 then "11-20$"
ELSEIF [Amount $]>21 and [Amount $]<30 then "21-30$" end
Use count as your measure aggregation.
For better solution, can you share workbook with sample data or data file
Thanks for trying to help but unfortunately that's not what I want. Thanks for your effort though.
so, what is it that you want?
1 of 1 people found this helpful
Here is my solution workbook.
See if it works for you.
On Tue, Jun 2, 2015 at 10:18 AM, Shijin Mathew <
it is like your screenshot, it's just based of the data that you supplied in your sample workbook.
Thanks for the sample solution. The solution partly works for me.
The second column "size" should be the count of orders which has the amount sum in that range.
In the example that you provided the size refers to the number of rows in the final table.
To make my request more clearer I added one more row to the raw data as below
suppose the raw data was
Order Number Amount($) Product Category 100 10 Low End 101 5 High End 102 3 High End 100 10 High End 103 7 Low End 102 17 High End 104 15 High End
I would like the end result to be
Order Category($) Count of Order High End($) Low End($) 0-10 ($) 2 5 7 10-20 ($) 3 45 10 20-30 ($) 0 0 0
You can see the column 'Count of order' column corresponding to "20-30 ($)" has count 3 now because I added another order with amount 15.
The second column "count of orders" should be the count of orders which has the amount sum in that range.
In the below example "count of orders" is 2 for each row since there are 2 orders whose sum of amount comes in each of that range - that is the part which I am having trouble implementing.