Hi There

When I run the following code I get a 'Formula error - duplicate dimensions across (independent) axes - when calculating a query axis' The code that is causing the error is highlighted in Bold, any ideas?

WITH
MEMBER [Product].[Flavour].[Total Products].[All] AS
'SUM({ [Product].[Flavour].[Group].Members})'

SELECT
{{[Frequency].[Year-to-Date], [Frequency].[Year-to-Date (Prior Period)]} * {[Measures].[Actual Hls], [Measures].[Budget Hls], [Measures].[Var % (Act vs Bud)], [Measures].[Var % (Act vs PF)] }} ON COLUMNS ,
{[Operation].[Regional].[Africa].Children, [Operation].[Regional].[Asia].Children } ON ROWS
FROM
[Sales]
WHERE
([Date].[Financial].[$PERIOD_NAME$], [Frequency].[$FREQUENCY_NAME$], [Product].[Flavour].[Total Products].[$PRODUCT_GROUP$], [SalesType].[External Sales])