August 3, 2015 at 1:35 am
Hello.
I have a pretty wierd problem with a Matrix. I have a couple of values and two groupings.
Some info about the matrix and dataset:
All the data comes from a Store Proc. The matrix have one parent grouping, Currency, And one child grouping, ProductName.
The wierd thing is that all the values from the Store Proc doesn't show in the matrix.
I have tried a lot of different solutions, ex: if i take a table instead, and remove the parent grouping (Currency), all the values from the Store proc ends up in the table, but if i add Currency as Parent grouping, i get the same problem as i did with the matrix.
Dont know how to solve this..
Hope that someone can help me!
Best regards,
Andreas
August 3, 2015 at 2:07 am
So i think i have a good idea of what the problem is now.
The problem is probably the grouping on ProductName, the dataset is showing some transactions for a specific user and some of the ProductNames are the same, SEK, but every product is specific with specific values. But since the grouping is on ProductName, im guessing that it only takes the first Product with that name. (?)
Do u guys have any tips on how to show all the values even if the ProductName occurs more then once?
Best Regards,
Andreas
August 3, 2015 at 2:13 am
Hi
Can you show some sample data and your query if possible ?
Maybe it is not necessary to do a grouping and just need a simple table ordered by productname??
Mohamed
:w00t: !!!GOOGLE IS YOUR BEST FRIEND!!! :w00t:
August 3, 2015 at 2:41 am
some ex-data:
Currency
--ProductName || TransactionDate || Businessevent || Volume || Price
------SEK ------------- 2015-05-24 ---------- Interest ----------- 10 ------- 900000
------Blabla----------- 2015-05-24 ---------- Sell----------------- 20 ------- 101000
------SEK ------------- 2015-05-24 ---------- Coupon ------------ 30 ------- 150000
The Productname can occure more the once for some products with a specific Businessevent.
Hope that helps.
Best regards,
Andreas
August 3, 2015 at 3:05 am
If you add the field BusinessEvent in the existing group "ProductName" ?
Will still it be correct for you ?
Mohamed
:w00t: !!!GOOGLE IS YOUR BEST FRIEND!!! :w00t:
August 3, 2015 at 4:02 am
I managed to solve the problem. Used a table instead of a Matrix and now it works great. I probably did something wrong in the first table.
Thank's for trying to help me guys!
best regards,
Andreas
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply