Extracting measure data based on store format

Hi All,

We have a business requirement of extracting sales data at two different intersections based on store format.

There are 3 store formats.

My sales measure is at day_itemstr_ intersection. Now I need to extract information like below

For Store format 1 - extract sales data at day_item intersection

day1 | item1 | sales across all stores for format 1

day2 | item1 | sales across all stores for format 1

.

.

For Store Format 2 & 3 - extract sales data at day_itemstr intersection

day1 | item1 | store 1 of format 2

.

.

.

day1 | item1 | store 1 of format 3

.

.

.

I thought of doing the below.

1. define a format ind at day_itemfrmt intersection and assign a value based on the format.