How do I make MDX show the quantity of sizes per item?
This query show what kind of sizes per item, but i want that he show me quantity per item.
Maybe need count or filter function, please help.
How i need write correct code?
select {} on 0,
{[Товары].[ItemID].[6863153]
* [Товары].[SizeID].[SizeID]} on 1
from [Analyse]
Maybe need to create member. please help me.
with
member [measures].[sizes_count] as
(existing [Товары].[SizeID].[SizeID]).count
select
{[measures].[sizescount]} on 0,
{[Товары].[ItemID].[6863153]} on 1
from
[Analyse]