Hi Sonja,

I can help you but I need to understand your question. Can you explain a little bit more about what you want to achieve?

What is the whole data and what is the subset? You can add a screenshot of your data structure or a dummy sample data or what your expected result should be.

Ossai

Can you post a sample data showing what you want to do? It doesn't need to be real data.

A screenshot of your dimensions and what you want to count will be okay also.

This will do

{Fixed [category]:SUM(IIF([category] ='office supplies' AND Year([Order Date])=2011 AND [country] ='Ireland',[sales],NULL))}

/

{Fixed [category]:SUM(IIF([country]='Ireland' AND Year([order date])=2011,[sales],NULL))} // of all countries. If you want Ireland then substitute SUM([sales])

Sonja,

Here's my approach. It doesn't require explicitly defining any category, year or country in the formula. It will also work when you filter by any dimension.

1. Create calculated field [Year]

YEAR([Order Date])

2. Create calculated field [% Total Sales]

{FIXED [Year], [Category], [Country]: SUM([Sales])} / {FIXED [Year], [Country]: SUM([Sales])}

See attached workbook. Hope this helps.

Ossai

{ FIxed question(variable): COUNT(IIF(question(variable)='a', question(variable),NULL))}

/

{ FIxed question(variable): COUNT(question(variable))}

Hi Sonja,

How does this new question relate to the previous one? Do you have a response variable (a, b, c, etc) for different countries and years? I'd like to know how many dimensions you have and how your data is structured. It will be difficult to give you a solution if you don't provide me with full information. Better still, you can mock up a dummy data set and attach it here.

Ossai