Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This should be so simple but I am drawing a blank
I have:
Product
A
B
C
D
Region
North
South
East
West
I want to add set analysis like below but it doesn't seem to work:
=sum(
{<[Product]={'A','B'}>}
Sales)
+
sum(
{<[Region]={'North','South'}>}
Sales)*.4
Hi,
Try this
(sum(
{<[Product]={'A','B'}>}
Sales)
+
sum(
{<[Region]={'North','South'}>}
Sales)) * .4
Try Below:
=num((sum({<[Product]={'A','B'}>}Sales)+sum( {<Region={'North','South'}>}Sales))*.4,'###0.00')
Hi,
may be try
rangesum(sum(
{<[Product]={'A','B'}>}
Sales)
,
sum(
{<[Region]={'North','South'}>}
Sales))
*.4