Segment by Model size and price

[israrkhan]

Hi Community,

i have an issue , creating segment of Product By Model_Size, And Quantity Sold..

i have to create buckets, on quantity, and price..

kindly look at attached sample..

if anyone could help me,

i will really appreciate it..

Many Thanks..

kindly ask me, i will explain in detail..'

i want to use dimension from Product Table. column name is Label, and want to see how much quantity and price sold on each bucket,

[israrkhan]

ANYONE PLEASE...!

[vishsaggi]

Hello Israr,

Could you please elaborate a little bit about your requirement.

Thanks,
V.

[sundarakumar]

There is clearly a cartesian product happenin in the sellout table. All the dimension have linear data.

Please correct the data model.

-Sundar

[ogster1974]

Here you go hope this helps

put your data in a pivot table.

Product and label dimensdion on quantity and price measures.

Regards

Andy

[israrkhan]

daer vishsaggi

if you see the data model, i have four tables, linked like below:

Bucket Table-->> Product Table --> Model Table -->> Transaction Table

i have range defined in the bucket table, minimum , maximum and label for the range.

i have to use Label from Bucket Table, as a dimension...

and i have to sum the quantity and Price from Transaction table,

and have to show the result in the pie chart on each bucket...

kindly have a look at bucket table...you will understand more...

many thanks

[israrkhan]

Dear Sundar,

i changed the data i removed the join from Bucket table into Product Table..

kindly have a look on data model now...

kindly explain me a bit more, how to correct data model, what is mean by All the dimension have linear data??

can you please...help on it??

see the new attachment please...

[israrkhan]

if you see, sum(sellout.qty) and sum(sellout.price) is repeating on each row in pivot table...

i want to see this result in pie chart, on each label column from bucket table...

many thanks