Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
1. I have Items Dimenssion and Companies Dimensions.
2. My Expression is 1.
I think because I have no data in the FACT table about the Item name "Ki Net Profit",
I see the 1 amount (from the expression) under null Company.
Any suggestion to solve that?
* When I put data for this item in the FACT I see 1 under the companies Dim, But I want another solution if exist.
* I need a layout solution only.
Thanks
Hi Meitar,
You could try an if statement to check if the Company has value, something like this
if
(
len(Company) <> 0,
count(Item)
)
Attached is an example QVW.
Regards,
Felipe.